Group Dimension Dynamic Axes

[#1]

Hello,

I was wondering if anyone would know how can i make my Axes dynamic, in the type of Max(Aggr(Exp,Dim)), but when that Dim is a group.

I cant define there a particular dimension because its a group, and when the selected dimension on the group switches, i would like to swtich the Dim as well.

Is there any way to do this?

Thank you

[Kushal_Chawda · Accepted solution]

Use this

Max(Aggr(Exp,$(=getcurrentfield([YourCyclicGroupName]))))

[lironbaram]

you could use a variable

let call is vDim you set the variable with this expression

=Getcurrentfield(yourdim)

and the axes function will be Max(Aggr(Exp,vDim))

[#4]

thanks alot