Excel Pivot Table Tip – Show Only The Top 10 Items In A Pivot Table


This tip is really useful if you have a Pivot Table with a large number of Row Items such a product ID’s and you only want to show your top selling products. You may have hundreds or even thousands of products but you only want to look at the data of your Top 10 selling products.

Instead of manually choosing the top 10 items… with a few clicks Excel does all of the hard work.

First we start with a standard Pivot Table- if you need more information on Pivot Table Basics you cam check out my Pivot Table Week posts right here.

Once your Pivot is created select the arrow to the right of the Row Header – in my example it is Product.

top 20 pivot table

 

  • Click Value Filters
  • Then Top 10
  • In the Top 10 Dialog Box you can fine tune the filter, but in this case I want the default of 10 items based on Total
  • To finish hit Ok

top 10 pivot table

Now your Excel Pivot Table will only display the top 10 produts based on their totals. This saves time sorting the Totals then manually clicking the top 10.

 

top 10 pivot table.1

More Excel Tips

  1. Create Multiple Reports From 1 Pivot Table
  2. Refresh All of Your Pivot Tables With 1 Click
  3. Prevent Pivot Table Bloating In Excel

 

[amazonjs asin=”0789748754″ locale=”US” tmpl=”Small” title=”Excel 2013 Pivot Table Data Crunching (MrExcel Library)”]

[amazonjs asin=”1932802444″ locale=”US” tmpl=”Small” title=”Learn Excel 2007 through Excel 2010 From MrExcel: Master Pivot Tables, Subtotals, Charts, VLOOKUP, IF, Data Analysis and Much More – 512 Excel Mysteries Solved”]

[amazonjs asin=”1118842243″ locale=”US” tmpl=”Small” title=”Excel Dashboards and Reports For Dummies”]

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts