How to Show Top N within each category using Rank in Tableau

[@willhunt370]

Thank you so much for posting this lecture, Darpan! You are a wonderful teacher and lecturer.

[@helpful_tipss]

Glad it was helpful! 🙂

[@shraddhamehta6547]

This was a great explanation! Thank you!

[@helpful_tipss]

Glad it was helpful! 👍🏻

[@deepakdhikale9211]

Thanks Darpan !! Thats really helped me in my current project

[@gayatrimoorthy9002]

This was a great video!

[@helpful_tipss]

Glad you enjoyed it! 🙂

[@mohdyusof3855]

thanks sir..u solve my problem...keep doing content even it is simple things.. because it hard for new bee

[@helpful_tipss]

Sure. Thanks a lot 👍🏻

[@zubinmacwan]

This was great, very helpful!

[@helpful_tipss]

Glad it was helpful!🙂

[@andyburrows7478]

excellent post Darpan, really helpful!!:)

[@helpful_tipss]

Thank you 🙂

[@babybru3154]

This video helped me in solving my problem! Thank you for creating useful content on tableau. Looking for more videos.

[@helpful_tipss]

Thanks Palak. I am happy that this video was helpful 👍🏻

[@chethupo]

Good job Darpan

[@helpful_tipss]

Thanks Chethan. Keep supporting the channel 🙂

[@mohammedabrar2871]

An amazing video brother! keep enlightening and helping us.

[@helpful_tipss]

Thank you. I am happy that this video was helpful👍🏻

[@MrWilrichardson]

Thanks for this, works great and easy video to follow. Now is it possible to add another measure name for color within each row? When I add the additional detail, the top N no longer follows the set number.

[@shaba9100]

Another good video bro 👌 it is very useful to me basically where are u from ?

[@helpful_tipss]

Thanks Bro. Keep supporting the channel 🙂

[@cutiepie8217]

What if you wanted to rank in reverse. For example the product with the lowest sales to be ranked us 1 and the product with the most sales with the highest rank.

[@helpful_tipss]

For that you can create a calculated field: Rank(sum(sales),’asc’)) and use that in column shelf. By default, the order is ‘desc’ that gives rank 1 to the product with highest sales and lowest rank to the product with lowest sales.

[@helpful_tipss]

I have uploaded a new video on this scenario. Link: kzbin.info/www/bejne/qoO7aaiIgtBjnLM

[@manjunathfattepur9122]

is it not applicable to state and city? where i am unable to sort the way you have shown

[@helpful_tipss]

Same steps will also work for state and city. If the bars are not getting sorted in desc order then you can try these steps also. Click on the city dropdown -> click on sort -> sort by Nested -> sort order desc -> field name Sales. Let me know if you face any difficulty

[@mishtiminky2013]

How to show top 3 as table instead of bar

[@Techno1497]

I have been asked By recruiter Find Top 10 Categories, subcategories wise product name

[@helpful_tipss]

Yes. This is one of the important Tableau question. Hopefully you would have been able to answer him 🙂

[@Techno1497]

@@helpful_tipss Nowdyz Interviewer ask to install tableau for case! Could u please share the important case question that will be very helpful

[@hk2in]

Isi ko pie chart banana ho toh kya karu