Cyclic Group

[bharatkishore]

Dear Member,

I have a small question regarding cyclic group.

I had created a cyclic group say A-->B-->C and i have two sheets.

I took that cyclic group as a dimension. Now my question is if i click on A it will go to B. And if i click on B it will go to C. Now if i click C it should go to chart which is in other sheet.

C data wil be in other sheet say sheet2. Can you please tell me how to do.

Regards,

RBK

[Jason_Michaelides]

Hi RBK,

For this I think you will need a combination of a variable, GetCurrentField() and a trigger.

1. Create a variable, vMyGroup, and set the expression to =GetCurrentField("MyGroup") where MyGroup is the cyclic group name.
2. Create an OnChange Variable Event Trigger (Settings > Document Properties > Triggers). Action = Layout > Activate Sheet. In the Sheet ID expression box put =If(vMyGroup='C','Document\SH02')

Hope this helps,

Jason