Changing DIM Fields with Filter

[tahirkhalil]

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

[swuehl · Accepted solution]

Maybe use a drill-down dimension group (create from the groups button on dimension tab or document properties).

[tresesco]

Create drill-down group in the dimension.

[tahirkhalil]

Hi,

Thank you - I was playing around with Cyclic Group

Thanks for the tips.

Tahir