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.
- 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
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.
- Create Multiple Reports From 1 Pivot Table
- Refresh All of Your Pivot Tables With 1 Click
- 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”]