Tableau: How to Display Correct Grand Total with a Rank Filter
Updated: May 14
Start with [State] on rows, and sum([Sales]) on Text.
Create a rank calculation. Rank(Sum([Sales]))
Add the calculation to the filter shelf. Keep only the top 3 values.
The grand total still displays the unfiltered amount.
Drag [State] onto the filter shelf.
Set the filter to be Top 3 by sum([Sales])
Now, the grand total is filtered to only the top 3
5 views0 comments