PIvot Table top Values

N

!ngeniuos

HI
I have to generate pivot tables and only extarct the top 20 or 40 values.
Excel 2003 has an option that could display the top values that I need - only.
i.e. ' Pivot Table Options >>Advanced settings >> "Top 10 AutoShow" '

Where do I find that function in Excel 2007 ??
 
A

AdamV

Right click a category (a row or column heading, in other words) >
Filter > Top 10.
This then gives a dialogue where you can change 10 to some other value,
filter top items, or percentage band etc.

Only tricky part is making sure you are filtering the right category eg
do you want the top 10 products by sales value? Or the top salespeople?
or the top months?

Hope this helps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Help! 1
Export Pivot table 1
Pivot Tables in Excel 2007 vs 2003 1
Average Top N performance in table 2
Pivot table report invalid 0
How to base a pivot table on another pivot table? 3
Consolidate Pivot Tables/Cache using Excel 2003 1
Pivot table question: Sorting the subgroup in a pivot table (whenusing the top 10 option for the sub 0

Top