Tableau: How to Display Correct Grand Total with a Rank Filter
Updated: May 13, 2021
Step 1:
Start with [State] on rows, and sum([Sales]) on Text.

Step 2:
Create a rank calculation. Rank(Sum([Sales]))

Step 3:
Add the calculation to the filter shelf. Keep only the top 3 values.
