How To Show Top N vs Others In Tableau

This tutorial will guide to show top N subcategories and group remaining subcategories in "Others" in Tableau.
Tableau Workbook: public.tableau...
Watch more videos on Tableau helpful tips here: • Tableau Helpful Tips
Please like, share and subscribe to my channel.
Thank you to every single person who has already subscribed to the channel.

[@shekharanalytics9337]

Hi Darpan , it seems this approach does not wok when filters are applied

[@helpful_tipss]

Which filters are you using? Try adding those filters to context. After that, I guess the filters should work correctly on the view.

[@shekharanalytics9337]

@@helpful_tipss ...thank you for the prompt reply

[@helpful_tipss]

Did it work?

[@shekharanalytics9337]

@@helpful_tipss .It worked like charm. Thank you again for quick response I wont hesitate to ask any further doubts :)

[@khandelwalshubham67]

Hi Darpan, just wanted to ask if we have more than one dimensions, then how are we going to select the pane down option in this approach ?
If i want top N vs others at pane level ?

[@ZimDataNative]

Today i was asked to create a similar view ,and i bumped into your video,you just saved my job ! Great video Darpan.

[@helpful_tipss]

Glad I could help! 🙂

[@AkshayParulekar-cm7hx]

I'm just making notes of this tutorial:
Drag sales to column shelf
Create Parameter > Top N
Create Set of State > Top > By field > Select Parameter we created
Create Calculated Field > IF [State Set] then [State] ELSE "Others" END
Drag that Calculated Field to Row Shelf
Show Parameter (Top N)
Done 👍🏻

[@helpful_tipss]

Thanks Akshay for the notes 👍🏻

[@aishwaryakannaujia6653]

You're a genius! This was very helpful for my assignment.

[@helpful_tipss]

Thanks Aishwarya. Keep sharing the videos with others 👍🏻

[@aishwaryakannaujia6653]

@@helpful_tipss sure and keep up the good work

[@puspanjaliprasad2644]

Thank you Darpan... Easy to understand 👍👍👍

[@helpful_tipss]

Glad to hear that. Keep watching the videos 🙂

[@yogendrameena1607]

Darpan, It is really a usefull video, thank you :)

[@helpful_tipss]

Thank you Yogendra 👍🏻

[@shaba9100]

Bro nice video thank u for making ...🙏

[@helpful_tipss]

Thank you 🙂

[@shaba9100]

@@helpful_tipss bro need video like what is Dimension and measure some interview questions and answers...make simple video

[@mefistofeles_miau]

it was so helpful

[@helpful_tipss]

Thank you Nallely 👍🏻

[@shashanknegi1255]

How will we do this along with Sub Category wise Rank ?

[@sandeshshetty4282]

instead of "top N based on sales", can we show flexibilty of multiple measure. eg if sales number are same for both sub category then it should consider other measure like profit for that 2 subcategory.

[@helpful_tipss]

It will consider only the sales measure.

[@ramseslandaverde1378]

Great video, muy bueno.

[@helpful_tipss]

Thank you Ramses👍🏻

[@Cricket-1983-cup]

Very good video

[@helpful_tipss]

Thanks Srinivas

[@MrChamago]

How to do it in case of multi dimensions? For each Category -> TOP N Sub-category and Others

[@helpful_tipss]

You can add the second dimension as the first field in the row shelf. Then you will get a view that will show top N vs others at pane level.
You can check this video:
ruclips.net/video/NKf9ixbzb5M/видео.html

[@shaikbasha5396]

bro need more videos on calculation part.

[@helpful_tipss]

Sure. I will upload more videos 👍🏻

[@yashagarwal31112]

If we use filters, this does not work accurately

[@helpful_tipss]

Which filters are you using? Try adding those filters to context. After that, I guess the filters should work correctly on the view