Using GetObjectDimension in Aggr

[timpoismans]

Is there way in how we can use the function GetObjectDimension in the Aggr-function?

GetObjectDimension returns the name of a dimension, but this is not sufficient for the Aggr-function. 

Anyone knows about a possible solution to this problem?

P.S.: Adding square brackets to the function as in '[' & function & ']' won't work.

Kind regards,

Tim P.

[JulieJoseph]

Hi praichubb,

I am having a similar issue where I want to do an aggregation based on the two dimensions which are selected (From a list of alternate dimensions)for a chart. Were you able to get a solution for this successfully. If yes, Could you please share the same here.

Regards,

Julie

[Alvaro__]

Instead of GetObjectDimension you can try using GetObjectField:

Aggr(Sum(Measure), $(='[' & GetObjectField() & ']'))

[Alvaro__]

Aggr(Sum(Measure), $(='[' & GetObjectField() & ']'))