GetObjectDimension for dynamic aggregation

[ali_hijazi]

Hello
I got a pivot table with several dimensions
I'm using the following GetObjectDimension(Dimensionality()-1) to know the name of the dimension at each row
how can I use this in an expression as dynamic aggregation:
avg(aggr(sum(), GetObjectDimension(Dimensionality()-1)))

it's not working as in the preview of the expression it's as follows:

[marcus_sommer]

You may use:

[$(=GetObjectDimension(Dimensionality()-1))]

[ali_hijazi · Accepted solution]

doesn't work

it evaluates to [GetObjectDimension(Dimensionality()-1]

but i tried this and it worked:

pick(wildmatch(GetObjectDimension(Dimensionality()-1)
,'Contract Type','Contract','act division','act department','act name','region','entity mgt','resource full name')
,$(vL.Rates.Denom.Group.By([Contract Type]))
,$(vL.Rates.Denom.Group.By([CNT]))
,$(vL.Rates.Denom.Group.By([ACT Division]))
,$(vL.Rates.Denom.Group.By([ACT Department]))
,$(vL.Rates.Denom.Group.By([ACT Name]))
,$(vL.Rates.Denom.Group.By([Region]))
,$(vL.Rates.Denom.Group.By([Entity MGT]))
,$(vL.Rates.Denom.Group.By([Resource Full Name]))

)

in the variable I pass the dimension to group by in Aggregation