Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table mutliple choice in page section
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table mutliple choice in page section
In the dropdown selector, select Custom, and set your options. 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. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=486188 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table mutliple choice in page section
Thanks, but there is no Custom option in pivot table filter section (or I
can't see it). You probably meant a normal filter on row data. Cheers. Użytkownik "Bryan Hessey" napisał w wiadomości news:Bryan.Hessey.1yoz2y_1132316101.5611@excelforu m-nospam.com... In the dropdown selector, select Custom, and set your options. 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. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=486188 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table mutliple choice in page section
Correct, I withdrew the comment when I correctly re-read your question, . . but obviously not soon enough. Mr Curious Wrote: Thanks, but there is no Custom option in pivot table filter section (or I can't see it). You probably meant a normal filter on row data. Cheers. Użytkownik "Bryan Hessey" napisał w wiadomości news:Bryan.Hessey.1yoz2y_1132316101.5611@excelforu m-nospam.com... In the dropdown selector, select Custom, and set your options. 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. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=486188 -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=486188 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table mutliple choice in page section
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table mutliple choice in page section
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Page Field Area Broken | Excel Discussion (Misc queries) | |||
How to get pivot table Time field to appear correctly | Excel Worksheet Functions | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) |