Need formatting help - is there a way to hide data (only visually)?
Hi all, would appreciate your help!
I am trying to replicate the format a senior director uses in their calculations for a very involved workbook. So far I've successfully replicated the data/calculations in Tableau, but I cannot get to the standardized visual formatting senior leadership prefers.
https://imgur.com/a/IHOiBNi
In the above I want to show the individual % breakdowns for measures only for row1 of each metric, but for rows 2 and 3 I just want to see the grand totals. However, because these are calculations I can't simply right click & hide the data as it changes the totals.
I tried changing the sheet formatting for calculations on rows 2 and 3 and setting the font format to white and the total to black but this doesn't seem to do anything.
Any suggestions how to get around this? I'm not sure how to resolve.