Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mr Curious
 
Posts: n/a
Default pivot table mutliple choice in page section

You're right- thanks again.
I am just wondering why this optiion is available in the row/column area and
is not available in the page area.

Cheers.

Uzytkownik "Debra Dalgleish" napisal w wiadomosci
...
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




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 mutliple choice in page section Mr Curious Excel Discussion (Misc queries) 7 November 22nd 05 08:55 AM
pivot table rmsterling Excel Discussion (Misc queries) 5 November 14th 05 04:40 PM
Pivot Table Cycling Through Page Fields Automatically nrehman Excel Discussion (Misc queries) 14 October 13th 05 07:32 PM
Pivot Table Page fields Ajit Excel Discussion (Misc queries) 1 October 12th 05 05:49 PM
Pivot Table Page Field Area Broken GarethG Excel Discussion (Misc queries) 1 September 29th 05 10:11 PM


All times are GMT +1. The time now is 08:31 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"