Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I understand how to show the top items in a pivot, but I can't do it when I have the field I want to base it on as the page item, it still shows all of them. Basically, I have the following fields: Date (column) Specialty (page) Count of Specialty (data) I only want the top 20 specialties based on count of specialty and I need it in the page field because I need to do the "show pages" function to end up with one tab per specialty. It works if I use it in the row, but not page. Please can you help? Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Page layout - page setup - items disabled | Excel Discussion (Misc queries) | |||
Missing Page Items Drop Downs | Excel Discussion (Misc queries) | |||
moving items within the page | Excel Worksheet Functions | |||
PivotTable - How to unhide page field items? | New Users to Excel | |||
Pivot Table dropping items from page item list | Excel Discussion (Misc queries) |