View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
watkincm watkincm is offline
external usenet poster
 
Posts: 19
Default Top 10 autoshow in PivotTables

I should like to display the top 20 performers by region in my pivot table by
using a page field (or other workable mechanism)- is that possible?
I need the pivot to show all (100%) of the contibutors in its normal state,
but then, by selecting the pagefield see only those top 20 contributors per
region...

Thanks
Mike Watkins