How to Display the Top N and Retain the % of Total

[@vinmos18]

Thank you, Andy! This video has helped me out so much more than you could ever know! Thank you!!

[@AnjalBangdiwala]

Thank you so much, Andy. This video saved my life! Very well explained. Just what I was looking for

[@magagsi]

Andy, Thank you so much for all amazing videos including this one! You are helping me saving my job :-)

[@morufataminu7909]

You just saved my life with this video. Thank you so much!!!

[@vizwiz]

Amazing! Thanks.

[@ChristopherOrtiz-n9z]

How would you take this 1 step further and show the aggregated % impact of the top n? In a single KPI/BAN

[@urp3126]

Thanks for the video, how can I get the total of sum of sales of top 5 category in a region with rank

[@summeral-hamdani7897]

This was super helpful, thank you so much! I appreciate the detailed explanation.

[@jemapellsj]

This is exactly what I wanted. Thank you. I appreciate that.

[@vizwiz]

My pleasure

[@damanjeetsingh880]

Thanks for the great video Andy. I am facing a challenge though, as soon as I drag the Rank function between Region and Sub-Category the percentage of total values disappear and I am not able to understand why or how to resolve this. Can you please help what's wrong?

[@sj8648]

This is very similar to one question in the Tableau Professional Certification Exam guide, I wonder if I may use INDEX() for ranking here too. Thank you!

[@beansgoya]

for anyone trying to do this in 10.3, there is no more advanced option. you just get a pop up window and you might need to click and drag your dimension to order them. for example, it might show sub category above category so the restarting option doesn't give you cateogry. just click and drag

[@13RALK]

Great video, but is it possible to show top 5 and then group all of the others as “others”? I need to show top 4 SKU that represent 80% of sales, but also group other 20sku that sum up the other 20% of sales.

[@joseroy2829]

Hi Roger,Did you get a solution for you question?Thank you..

[@ramseslandaverde1378]

Hi Andy, have you any tutorial to show in the same chart something like the Top 90% of and the Bottom 10% of sales (thinking in individual products EAN)?

[@futureframe]

Excellent video, clear and to the point - thank you!

[@haonanliu4609]

Great thanks, Andy. your video helps me a lot!

[@vizwiz]

Happy to help!

[@tighthead03]

Hi Andy, I wish to use this approach in my interactive tooltip on a map which I have discovered from one of your other videos, thanks! If I wanted to display the latest top N (last date) for say region how would this work with a context filter? Can I use LAST()==0 on the filter shelf and set it to TRUE?

[@loomdoby]

I have been following you on tabelu you are one of the best I want to learn tableu from. You let me know if you provide remote training.. I would also like to take certification

[@priyankbahuguna1057]

Hi Andy , Love your content ! Is there a way to show top N and group the other remaining items into one total in the end ?

[@myronlewis5752]

I want the top 5 Subcategory as stacked bar with Overall sales per region and top 5 products per region on region level. can you help

[@vizwiz]

This week's Workout Wednesday might be exactly what you're looking for. public.tableau.com/app/profile/andy.kriebel/viz/WOW2022Week50-InteractiveProportionalBrushing/WOW2022W50

[@ricomitchell3443]

So I have an issue regarding identical rankings for Suppliers.... these suppliers have the same value for overall percentage. How do I provide unique rankings to the suppliers with the same percentage? Ex. (below is example how it shows, with multiple suppliers showing ranking #1) Vendor Name Rank XYS, Inc. 1. Atonomouse 1. CCGT 1. Gulpeht 1. Can anyone help with this problem?

[@JD_018]

Hi Andy - can a single parameter control two calculated fields simultaneously? Many thanks

[@vizwiz]

Absolutely. Just refer to the parameter inside the calculated field.

[@JD_018]

@@vizwiz thanks Andy, would you be able to demonstrate that at all? Essentially what I’m looking for is parameter A to control two different measures, so measure 1 and measure 2.

[@mrpennington72]

Great video, as always, sir. Appreciate your efforts on these.

[@vizwiz]

+Michael Pennington thanks for the kind words. I often have to refer back to them to remember how I did something, so it's helpful for me too.

[@pareshpande9095]

How to remove 0% value label from pie chart

[@pareshpande9095]

I need help

[@RealEstateData]

Andy, very useful video. I created same view using the technique.

[@hareeshtummala4836]

Thank you Andy. This is great stuff.

[@blad_3]

This video was of great help by just solving my purpose(showing top N values dynamic to filters). It would be good to know if there is a way to show total % of top N too. Thanks a lot Andy!

[@kotainlive]

Hi Gowtham, how you resolve to show total % of top N?? thanks

[@harshadhardas1648]

Thank you, tried all, working perfect.

[@PutuEkaSuryaAditya]

How about three level

[@sagarreddy6716]

thanks andi,i want to know if we can recalculate the top to makeup to 100%.share your thoughts.

[@ranjitbommidi3442]

If you want to recalculate the percentage then you can filter the subproduct directly without creating any table calculations. I mean filter subproduct by topN using parameter

[@sateeshp5947]

That's a great post Michael.. Btw.. How is it able to retain the % . What's the logic behind that. Could you pls explain

[@vizwiz]

+sateesh p if you watch the video, you'll see that I created a T/F calc for Rank to Show. I choose the True and what tableau is doing is basically "hiding" the false. This works because it's a table calculation and the order of operations stipulate that this filter be applied AFTER the % of total calc.

[@sateeshp5947]

+Andy Kriebel Thanks Andy..It's very clear now. Thank You so much for your time.

[@Badabing1967]

Wonderful tutorial!

[@sj8648]

Very helpful tutorial!

[@praveenpenta5273]

Hi, thanks for good video, how can we show Top N of total % ? I did it but my client asking Top N of % should be 100. please waiting for your help...

[@ranjitbommidi3442]

Remove Boolean calculation as filter.Try to create calculated field for sales .if rank

[@joseroy2829]

@@ranjitbommidi3442 I tried the way u said but its giving the same result.Thank you

[@ranjitbommidi3442]

@@joseroy2829 Hi Jose ,what do you need exactly

[@ranjitbommidi3442]

@@joseroy2829 Do you want the percentage to recalculate after filtering topN??

[@ranjitbommidi3442]

If you want to recalculate the percentage then you can filter the subproduct directly without creating any table calculations. I mean filter subproduct by topN using parameter

[@maxinthedam]

SUPER HELPFUL. tHANKS!

[@SMon2023]

Great thank you! but who is Jeremy?

[@vizwiz]

It's the name we give the little triangle drop down. Inside joke. :-)

[@rafigabasov]

Thank you, it is a great explanation!

[@vizwiz]

Glad it was helpful!

[@defencearasu]

This is really helpful !

[@anabeleunice1083]

This is amazing

[@SannareddyHarshavardhan547]

Thank You