Excel: Show Top 10 results in a pivot table in Excel 2003/XP/2000/97
Also learn how to show Top 10 results in a pivot table in Excel 2007.
Question: In Excel 2003/XP/2000/97, how do I show only the top 10 results in a pivot table?
Answer: Select a row heading in the pivot table. In this example, we've chosen the row heading called Order ID.
Right-click and then select "Field Settings" from the popup menu.
When the PivotTable Field window appears, click on the Advanced button.
Under the AutoShow options, select Automatic. Select Top and the number of items that you wish to view. Now click on the OK button.
In this example, we've chosen the Top 10 values based on the "Sum of Quantity" field.
This will return you to the PivotTable Field window. Click on the OK button.
Now when you view your spreadsheet, you should only see the top 10 values based on quantity.
