How to hide/remove the Grand total for a specific column in Cross table

[Prashant]

Hi Team,

 

Is there we can hide or remove Grand total for a specific column in Cross table
In the attached screenshot, yellow shaded one to be removed.

Appreciate your inputs be it related to custom also.

Thank you!

[David Boot-Olazabal]

Hi Prashant,

I don't think this is possible, certainly not with the out of the box functionality that lets you style individual rows only (instead of cells which you are looking for).
I also didn't have luck with custom expressions for the summation of the columns, as the Grand Total is derived automatically based on the cell values (you can't create your own Grand Total and insert it). Last option I tried, was to add an empty row below and tried to add the custom expression in there as well. That also failed, since the extra row became part of the cell values 'block'.

So, all things considered, I would advise you to create an enhancement request which can style cell values of a grand total individually, via our ideas portal https://ideas.spotfire.com/.

Kind regards,

David