MS Excel: Show Top 10 results in a pivot table in Excel 2011 for Mac
Also learn how to show Top 10 results in a pivot table in Excel 2011 for Mac | Excel 2010 | Excel 2007 | Excel 2003/XP/2000/97.
Question: In Excel 2011 for Mac, 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".
Click on the arrow to the right of the Order ID drop down box.
A popup window will appear. In this window, click on By value and select Top 10 from the popup menu.
"Top 10" should appear in the window, replacing the "By value" drop down. Next, enter 10 in the field directly below to specify that you wish to see the top 10 items.
Then close this popup by clicking on the X in the top left of the popup.
Now when you view your spreadsheet, you should only see the top 10 Order IDs based on the Sum of Quantity.
