Then close this popup by clicking on the X in the top left of the popup. Next, enter 10 in the field directly below to specify that you wish to see the top 10 items. "Top 10" should appear in the window, replacing the "By value" drop down. In this window, click on By value and select Top 10 from the popup menu. If you wish to retrieve the highest 10 "Sum of Quantity" values, you will need to use the Bottom 10 solution.Ĭlick on the arrow to the right of the Order ID drop down box.Ī popup window will appear. In Excel 2011 for Mac, the Top 10 will return the lowest 10 "Sum of Quantity" values. IMPORTANT: Please note that "Top 10 functionality" in Excel 2011 for Mac works differently than the Windows Excel versions (ie: Excel 2010, 2007, 2003, etc). Question: In Microsoft Excel 2011 for Mac, how do I show only the top 10 results in a pivot table?Īnswer: In this example, we want to show the top 10 Order IDs based on the "Sum of Quantity".
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |