Question: How do I show only the bottom 10 results in a pivot table in Microsoft Excel 2013?
Answer: In this example, we want to see the bottom 10 Order IDs based on the "Sum of Quantity".
![Microsoft Excel](http://www.techonthenet.com/excel/pivottbls/images/bottom10_2013_001.gif)
Click on the arrow to the right of the Order ID drop down box and select Value Filters > Top 10 from the popup menu.
![Microsoft Excel](http://www.techonthenet.com/excel/pivottbls/images/bottom10_2013_002.gif)
When the Top 10 Filter (Order ID) window appears, select Bottom, 10, Items, and Sum of Quantity in the respective drop downs. Then click on the OK button.
![Microsoft Excel](http://www.techonthenet.com/excel/pivottbls/images/bottom10_2013_003.gif)
Now when you view your spreadsheet, you should only see the bottom 10 Order IDs based on the Sum of Quantity.
![Microsoft Excel](http://www.techonthenet.com/excel/pivottbls/images/bottom10_2013_004.gif)
No comments:
Post a Comment