Is it possible, to change variable value depending on Pivot column expansion or collapse . . .

[prasad_dumbre]

Hi All,

Can you please suggest a way through which we can change a value of a variable depending on Pivote Table column expansion.
Eg: If we expand a column then variable should hav value +1; and when collapse the column, variable should contain the value -1.

I hope, I was able to explain the requirement properly.

Kindly guide  . . .

[Gysbert_Wassenaar]

No, that's not possible. That kind of mouse event can't be captured to use for setting a variable.

[prasad_dumbre]

Hi Gysbert,

Thank you for the reply. Then is it possible to expand/collapse a pivot column on click of a button ?