Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jco
 
Posts: n/a
Default Pivot table page filter not accepting multiple values. Workaround?

I am trying to make a pivot table where I need to filter the data by the
values in a certain data field ("field 1"). I need to allow records with
either "this or this or this" value in the field 1. The problem is that the
pivot table page filter only allows for one single value to be chosen.

I do not want the field 1 to be shown in the column fields (where it
otherwise would be possible to chose multiple values), since I am not
interested to get the data grouped by the value in field 1 and since I am
also making a pivot chart where the field 1 will blur up the picture.

Any suggestions?
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

Double-click on the page field button
In the Hide list, select the items you don't want displayed
Click OK
It will display (Multiple Items) instead of (All)

Or, drag the page field to the row area
Select the items you want to filter for, and deselect the rest
Drag the field back to the page area.

jco wrote:
I am trying to make a pivot table where I need to filter the data by the
values in a certain data field ("field 1"). I need to allow records with
either "this or this or this" value in the field 1. The problem is that the
pivot table page filter only allows for one single value to be chosen.

I do not want the field 1 to be shown in the column fields (where it
otherwise would be possible to chose multiple values), since I am not
interested to get the data grouped by the value in field 1 and since I am
also making a pivot chart where the field 1 will blur up the picture.

Any suggestions?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #3   Report Post  
jco
 
Posts: n/a
Default

Thanks very much, Debra!

That was quite simple, - when you know it :-).

Maybe someone should give Microsoft a hint that the logic here could
preferrably follow the logic in the columns/rows fields?

Thanks again.

JCO

"Debra Dalgleish" wrote:

Double-click on the page field button
In the Hide list, select the items you don't want displayed
Click OK
It will display (Multiple Items) instead of (All)

Or, drag the page field to the row area
Select the items you want to filter for, and deselect the rest
Drag the field back to the page area.

jco wrote:
I am trying to make a pivot table where I need to filter the data by the
values in a certain data field ("field 1"). I need to allow records with
either "this or this or this" value in the field 1. The problem is that the
pivot table page filter only allows for one single value to be chosen.

I do not want the field 1 to be shown in the column fields (where it
otherwise would be possible to chose multiple values), since I am not
interested to get the data grouped by the value in field 1 and since I am
also making a pivot chart where the field 1 will blur up the picture.

Any suggestions?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Repeats Names in multiple rows Riccardo Excel Discussion (Misc queries) 3 October 3rd 06 09:53 PM
Pivot Table Cycling Through Page Fields Automatically nrehman Excel Discussion (Misc queries) 14 October 13th 05 07:32 PM
pivot table sort entries that don't yet appear in table rachael Excel Discussion (Misc queries) 11 September 19th 05 11:29 PM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 08:24 PM
Pivot Table - Filtering Page Field R. G. Ingersoll Excel Discussion (Misc queries) 1 January 29th 05 08:29 PM


All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"