Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Any idea about it ?