Hide columns in pivot table except for 'total'

kirsten_dc — Mon, 13 Mar 2023 14:49:40 GMT

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

Re: Hide columns in pivot table except for 'total'

Or — Mon, 13 Mar 2023 14:51:09 GMT

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.