Hide columns in pivot table except for 'total'

[kirsten_dc]

Hi,

is there any possibility for hiding all columns except for the total column?

This is my expression for only showing values for total: if(SecondaryDimensionality()=0, sum(ArticleAmount))

But I want to hide the columns if they are not the total-column

Regards,

Kirsten

[Or · Accepted solution]

As far as I know, there is no way to do this. As a workaround, you could consider adding the Total column as a calculated dimension instead.