Thread: Page Filters
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Page Filters

You can temporarily move the page field to the row area, where the
dropdown list will have check marks, and select the items you want.
Then, move the field back to the page area.
Or, double-click on the page field button.
In the Hide list, click on the items that you want to hide.

Hile wrote:
Pivots allow you to add criteria at the page level, but when you drop it down
you can only select one thing. How can I make it so I can select multiple
variables?

Otherwise, how can I add a filter to the pivot that I can select and
deselect w/o making the specific data show on the pivot table.

i.e. I have a number of values
Unit# - Unit Use - Unit Class
123 P E
124 P R
111 P S
133 P R
122 P E
132 P E

I want to see units equal to E and R, but I don't want this column showing
on my table



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html