Hi deepesh moad,
Tableau cannot turn on Grand Totals for Discrete Measures (when on a view).
It means that if one would place RANK() sorting Blue Pill on a view,
Grand Totals couldn't be shown. And vice versa.
To work around this, one could use
"straight" TopN filter on Customer ID
together with Context filter on Date.
Please find the attached.
Ranking Issue_YF.twbx 476.3 KB