Pivot Table - Using Dimensionality to show a column

[#1]

Hi guys,

I have a pivot table and I'm trying to show or hide a column of it.

When the user starts to expand the column one or more columns don't have to be show.

I found a solution using a button that set a variable. Then I test the variable value in the conditional property of the column and it works fine.

I'd like to do that without using a button.

I mean, when the user starts to expand the columns, automatically one or more column are not visible. When they callaps all , that colums must be shown again.

I wanted to use the Dimensionality() function in the conditional property but obviously it doesn't work.

Is there a way to do what I'm looking for ??

Thank you so much in advance

Best regards

Giampiero

[#2]

Any idea about it ?