How to create Dynamic Scaling based on selected Dimension

[#1]

I am working with a trellis chart where the user can select a range of dimensions to flip in and out dynamically.  Based on the dimension selection (i.e. Zone) I would want to scale the data by X but when I drill in on a Zone and flip the dimension to Branch as another example, I want to then Scale the data by Y.

Is there a formula or something that can help me do this?

Thanks for any assistance you can provide!!

[MarcoWedel]

Hi,

if you're using dimension groups, then you can use limit expressions for your axes like

Pick(Match(GetCurrentField(YourGroupName),'Zone','Branch'),X,Y)

hope this helps

regards

Marco