Hide dimension based on group

[#1]

Hi All,

I have a pivot chart object and I am using a cyclic group for the first dimension. The second dimension in the pivot table is a simple field(not cyclic group). The cyclic group has 2 dimensions the user can chose from(say A and B). If the user select A, I want to hide the second dimension in th epivot table. Is this possible?

Please advise and thank inadvance for your help.

[phaneendra_kunc · Accepted solution]

Use this enable condition for the dimension you are trying to hide.

GetCurrentField([Cycle Group]) = 'A'

Attached has example