ADVERTISEMENT

MS Excel: Show Bottom 10 results in a pivot table in Excel 2003/XP/2000/97

---

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.