![]() |
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