ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   top items in a pivot by page (https://www.excelbanter.com/excel-discussion-misc-queries/205808-top-items-pivot-page.html)

Tuxla

top items in a pivot by page
 
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


All times are GMT +1. The time now is 10:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com