View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default pivot table mutliple choice in page section

It may be easier to drag the page field to the row area, and use the
check boxes in the dropdown list, to show or hide the items.
Then, move the field back to the page area.

Mr Curious wrote:
It is indead some solution - thank you.
If you want to change frequently values on a list which is pretty numerous
this solution is not user friendly.

Cheers.



Uzytkownik "Debra Dalgleish" napisal w wiadomosci
...

Double-click the page field button
In the Hide items list, select the items that you want to hide
Click OK

The page field dropdown will say (Multiple items)

Mr Curious wrote:

Normally in page (filter) section I can choose only one or all items, but
it
would be very useful to choose a few items at once.

Is it somehow possible?

Cheers.



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






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