tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities DigMinecraft
Share this page:

MS Excel: Show Top 10 results in a pivot table in Excel 2010

See solution in other versions of Excel:

Question: In Microsoft Excel 2010, how do I show only the top 10 results in a pivot table?

Answer: In this example, we want to show the top 10 Order IDs based on the "Sum of Quantity".

Microsoft Excel

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

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

Microsoft Excel

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

Microsoft Excel