Hide Expression Columns Apart From Total

[#1]

Hi all,

As per the attached screenshot, I'd like to only show the TOTAL column for one of my expressions.

In the attached screenshot, I'd like to see All the 'S' values, and then only the very last 'P' value which is the total.
I don't want to change the font color as this will still leave the column and will also hide the TOTAL 'p' column.

Any ideas?

Thanks

[Gysbert_Wassenaar · Accepted solution]

That's not possible. You can try adding a calculated dimension to a column with the p totals on the left side with the other dimension columns. If you have a dimension column DimA and an expression sum(Value) the you could use =aggr(sum(Value),DimA) as calculated dimension.

[#3]

Great thanks very much. That has done the trick! Much appreciated.