I have already used this alternative but when I drill down in dashboard on particular segment or site this does not give the me the Top 5 Products for that particular segment or site
If you have any the other option so please let me know it would be really helpful for me
Thanks for your reply
keep the segment in context which in filter.
Please use below calculation for Rank:
and make it discrete then drag to filter marks.
Also, you can do so with top filter feature in tableau, to make it dynamic you can create a parameter into it.
Sheet Attached for your reference:
TopN.twbx 396.8 KB