See solution in other versions of Excel:. If you want to follow along with this tutorial, download the example spreadsheet. Steps to Show the Bottom 10 Results in a Pivot Table To show the bottom 10 results in a pivot table in Excel 2016, you will need to do the following steps:.
Select the cell that contains the results to filter. In this example, we have selected the Order ID field which is cell A1 (we want to show the bottom 10 Order IDs based on the 'Sum of Quantity'). Click on the arrow to the right of the Order ID drop down box and select Value Filters Top 10 from the popup menu.
Mar 28, 2016 - The status bar at the bottom of Excel's window can tell you all kinds of interesting information. Even better, you can easily customize the status bar to show just the information you want. Windows Mac iPhone Android. The Average, Count, and Sum options on the status bar are enabled by default. Locate the status bar at the bottom of the window. Right-click that status bar to display a list of options.
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. Now when you view your pivot table, you should only see the bottom 10 Order IDs based on the Sum of Quantity.