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 |
Top 10 autoshow in PivotTables
Sort descending then filter in the pivot
"watkincm" wrote: 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 |
All times are GMT +1. The time now is 10:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com