Top N within Partitions/Groups/Category - Tableau Rank Function
Вставка
- Опубліковано 15 жов 2024
- ☝Check my latest course and go beyond certification!
Use CODE: DATA50 to get discount up to 50%
➥learnwithrites...
🗣 CONNECT WITH ME ON SOCIAL
💥How to rank with Power BI 💥
► dancesingwithd...
💥KB Article 💥
► kb.tableau.com...
💥Twitter 💥
► / riteshbisht01
💥Linkedin💥
► / ritesh-bi. .
💥Tableau Community 💥
►community.tabl...
💥Workbook Optimizer 💥
►help.tableau.c...
Use RANK()
Rather than INDEX, you can use the following calculation:
RANK(SUM([Sales]))
This calculation has the sort order built in, so you can skip the Sort Order step above when using this method.