Spreadsheet 123 Excel 2003, XP, 2000, 97 FAQs: Display Bottom 10 Results

Also learn how to show Bottom 10 results in a pivot table in Excel 2007.

Question:  How do I show only the bottom 10 results in a pivot table in Excel 2003/XP/2000/97?

Answer:  Select the row heading in the pivot table. In this example, we are selecting the Order ID heading.

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 Bottom and the number of items that you wish to view. Now click on the OK button.

In this example, we've chosen the Bottom 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 bottom 10 values based on quantity.