top of page

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.

Step 4:

The grand total still displays the unfiltered amount.