totn Excel 2016 Pivot Tables

MS Excel 2016: How to Show Top 10 Results in a Pivot Table

This Excel tutorial explains how to show the top 10 results in a pivot table in Excel 2016 (with screenshots and step-by-step instructions).

If you want to follow along with this tutorial, download the example spreadsheet.

Download Example

Steps to Show the Top 10 Results in a Pivot Table

To show the top 10 results in a pivot table in Excel 2016, you will need to do the following steps:

  1. 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 top 10 Order IDs based on the "Sum of Quantity").

    Microsoft Excel

  2. Click on the arrow to the right of the Order ID drop down box and select Value Filters > Top 10 from the popup menu.

  3. Microsoft Excel

    When the Top 10 Filter (Order ID) window appears, select Top, 10, Items, and Sum of Quantity in the respective drop downs. Then click on the OK button.

    Microsoft Excel

  4. Now when you view your pivot table, you should only see the top 10 Order IDs based on the Sum of Quantity.

    Microsoft Excel