Question
How to get the rank by the cumulative value of the rows instead of by each column?
Last Modified Date: 01 Jun 2023
Environment
- Tableau Desktop
Answer
Below is an example to calculate the rank based on cumulative sales for each category.1. Add Category to Rows.
2. Add YEAR(Order Date) and SUM(Sales) to Columns.
3.Create a calculated field and name it Total sales per category.
{ EXCLUDE DATEPART('year', [Order Date]) : SUM([Sales]) }
4. Create a calculated field and name it Rank.
RANK(SUM([Total sales per category]))5. Add Rank to Label.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials