Excel Pivot Table: How to Show Top 10 Values

This tutorial shows you how to display a Top 10 in an Excel Pivot Table.

In this video, a pivot table summarizes some product sales. With a Top 10 Filter, I can quickly show the top products, and compare top and bottom product sales.

Use the Top 10 filter feature in an Excel pivot table, to see the Top or Bottom Items. You don't need complex formulas , just use built-in filters.

You can summarize your data by creating an Excel Pivot Table, and then use Value Filters to focus on the top 10, bottom 10 or a specific portion of the total values in your data.

For example, instead of showing the total sales for all products, use this type of filtering to show just the top 10 products, or narrow it down to the top 3.

Also, if you want to focus on the bad performers, you can use a value filter to find the bottom 5 products.

If you find that useful, please give a like to this video and subscribe to my channel🤓

Timestamp:
00:00 Intro
00:30 Step 1: Find the correct button
01:24 Step 2: Sort the pivot table
01:47 Now, you have your Top 10🤓

🔴 RECOMMENDED VIDEOS/PLAYLISTS

Feeling generous? I like coffee.🤗

[cogwheelLearning]

Need help with Pivot Tables? 😰
✅I created a playlist with all the tips & tricks you'll need to master them:

[tamaraorusa]

Straightforward and easy to understand. Thanks!

[gerardthompson]

Bang! Right to the point. Thanks for this quick help.

[joshuaburke]

Hi, thanks for the video. What if I had two categories in the rows? For example I had Team and under that listed the players, and I wanted to get the top 10 players for each team

[johansanjaya]

hello, what if we want to show top 3 value, but there are some values that has same value, like books 3614, baby 3614, games 3614. i have tried that filter but it shows more than 3 values and row labels that has same values keep appears

[eldoulis]

If I refresh the data of the pivot table, will the new values appear in the to 10 ? Or I need to re-Short the table ?

[kenneth]

How would I do if I have duplicate accounts n would like to merge and want to sort the top 10

[learnbahrainiarabic]

How to do same to check month wise by putting month filter in column

[milenakeleynikov]

Hi how to cancle showing only the top? Uncheck doesnt work for me

[denomanoamedi]

what if there are same values, say 9th 10th 11th 12th are all same now how to show only till 10th