Below is the situation.
The % value in the colored column is coming fine because it is a rolled up value which tableau handles on its own while giving the grand total.
However, the next two columns are showing % values in thousands because they are raw data fields in the backend and hence are simply getting added like numbers.
What I need to get done - to be able to calculate grand totals for these two columns separately i.e. overriding tableau calculation method for those particular columns.
Is this doable?
Many thanks in advance.
May be Two-Pass Totals could help:
For your 2nd and 3rd columns you could choose
Total Using (Automatic) --> Average
Hope this makes sense.