topic GetObjectDimension for dynamic aggregation in App Development

GetObjectDimension for dynamic aggregation

ali_hijazi — Tue, 25 Mar 2025 10:57:34 GMT

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:

Re: GetObjectDimension for dynamic aggregation

marcus_sommer — Tue, 25 Mar 2025 14:25:40 GMT

You may use:

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

Re: GetObjectDimension for dynamic aggregation

ali_hijazi — Tue, 25 Mar 2025 14:57:56 GMT

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