Show Top Ten Results - Excel PivotTable Tricks

Filter your Excel PivotTable to display only the top ten results. This technique can be really awesome in Excel dashboards when space is limited.

This video tutorial shows how to filter for the top ten results in an Excel PivotTable dashboard. The dashboard is set up with Slicers for interactivity. The top ten selling products created in the lesson complete the dashboard.

The video also shows how to stop columns from autofitting when data is filtered. This is a really useful skill when creating interactive dashboards.

You can also get your PivotTable to display the top 5, or top 15 results. It can also be used to display percentages such as top 10% or bottom 10%.

Here are the timings for the video.
00:00 - Introduction
01:55 - Create the PivotTable
03:42 - Show top ten in Excel PivotTable
05:26 - Connect the Slicers to the top ten PivotTable
06:17 - Stop PivotTable columns widths changing

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[michalroesler]

Great Video - I'm watching it again, so much value in it.

[tokyo]

U deserve a like and comment. I had an interview and got it done write. Thanks a lot. I asked my friends who work as BA but have no knowledge sadly.

[sandhyabansal]

Nice video - sometime it happens if you choose, in this case - product name as a slicer as well - the moment you play around the slicer 'product name' it will loose the 'Top 10' condition and begin to show you all the values :( .. do you have any suggestion for that please. Many thank, keep posting good videos - Thank you

[felipemendes]

Sir, I thank you for sharing your knowledge.

[mohammadsi]

Hi Sir, salute you, impressive and excellent explanation! I was expecting and searching like your vdo. Thanks again.

[roshanmishal]

For TOP 10 values
this will work properly when we switch within slicer values
but if we clear the filter entire pivot table will appear
any solution to this scenario ?

[suryadaily]

i put not the table but as chart, and sometimes the chart broken not only showing top 10 but more than that..

[faisalkhalaf]

Can I take a copy of this work and amend it?

[aakashj]

How did you added first slicer, ( months) in that grid format. Iin my case all slicers comes in list format ( like the 2nd slicer)

[riyankanag]

How to adjust the height and width in a pivot chart in EXCEL ?? plz tell me ...

[gregharrison]

Not sure why on an interactive dashboard you made your Top 10 feature a Table. It's not in line with the graphics vis-a-vis pivot charts to essentially add a cross-tab. A Top 10 using a bar chart sort ordered Largest to Smallest for instance, where in the table sort you use the opposite sorting method, smallest to largest, to get the chart to show the Top 10 values in Descending order.

[MrPaddy]

what i am having issue with is that when i create the slicer for the pivot i clicked on the other slicer to change the charts my chart should only show 10 items but my chart when i click and remove the slicer filter it again shows me all items and its annoying, can you let me know how i can change that ?

[anandkumar-xuyq]

Can we put the option top 10, Top 15 etc as slicer. If so? Then how?

[jamesturner]

Thanks for the video
4:33 is there some way you can adjust the top 10 list so it shows the top 10 items and then the "others" (i.e. the sum of the rest)?

[upasna]

Thank you for this video! Is it also possible to have a pivot table with the top 10 and then an aggregate of the remaining items?

[harimuthyam]

How to sort the same table when 2 values are same and should be sorted by their name.

[gopeshsalhotra]

@computergaga thanks for sharing this video. I have an issue with my top 10 list. When connected to my slicers, my top 10 list defaults (have around 80 customers) are you able to give advice on this?

[arkdum]

Hello, i like the buttons on your chart. If you have a video about making them i would really really like to know how. Please reply as soon as you can.
Many thanx

[elegbedeoluwasogo]

Can someone recommend how to plot top 5 from a pivot table

[greghicks]

Do you have a video on how you made the other 2 charts?