Pivot Dynamic Dimension Sum with highest Value

[ManuelRühl]

Hi, I need this pivot table (example generated by test script):

The highest sum(Expression1) per Dim1 must be presented in the pivot table like that.

I tried nearly everything Max,Aggr,Firstsortedvalue etc ...

Any suggestions?

Thanks in advance!

[alejandroquinones · Accepted solution]

Hey @ManuelRühl,

I got it using two Aggr functions:

Aggr(Max(Aggr(Sum(Expression1), Dim1, Dim2)), Dim1)

Kind regards

[Lech_Miszkiewicz]

Same answer as @alejandroquinones