Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
I have a requirement, I need to change the DIM value according to the selection.
I have hierarchy in data for Zone, Region and City - Now by default my dimension will be
a) Zone
if I select/Click any Zone Bars from the chart - the dimensions will change to
b) Region (related to specific/clicked Zone)
Once I select some specific Region - the dimension should change to
c) City (related to that clicked Region)
See attached test doc with data populated.
Thanks for your help.
R,
Tahir
Maybe use a drill-down dimension group (create from the groups button on dimension tab or document properties).
Maybe use a drill-down dimension group (create from the groups button on dimension tab or document properties).
Create drill-down group in the dimension.
Hi,
Thank you - I was playing around with Cyclic Group
Thanks for the tips.
Tahir