Remove/Hide Rank display for Grand Total

[nathan.nguyen]

Is there a way to remove/hide Rank value for Grand Total? I look in the Rank properties and do not see where I can do this.

[christianp (Christian)]

If you go to the data analysis panel of your table and then click on the pencil icon beside the rank measure, you should see an option to create a custom totals calculation. You can use this and then simply place a null into the formula bar and that should turn the grand total cell for rank into a blank.

[nathan.nguyen]

you go to the data analysis panel of your table and then click on the pencil icon beside the rank measure, you should see an option to create a custom totals calculation. You can use this and then simply place a null into the formula bar and that sh

That works, thank you!