View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tuxla Tuxla is offline
external usenet poster
 
Posts: 12
Default 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