Last Modified Date: 20 Jul 2023
Environment
Tableau DesktopAnswer
The below example can be found in the attached workbook, which uses the example data source Superstore.-
Create a Calculated Field [LookupValue]
LAST()
What this does is Index the columns, so that the far most right column is always 0 -
Create a Calculated Field [Across_Value]
WINDOW_SUM(IIF([LookupValue]=0,([Value]),0))
What this does, is check each column for the value of LAST(). If it is 0 (The last column), then we sum the Measure amount, else, we have 0. -
Create a Calculated Field [Rank]
RANK([Across_Value])
What this does is Rank the SUM of the right most column in Tableau.
For the COMPUTE USING for RANK
Rank > Table Down
Across_Value > Table Across
Lookup > Month Then place the [Rank] field on the worksheet to the far most left as a discrete measure, and hide the header.
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