Aggregation functions

[Joaquin_Lazaro]

Hello:

I have this expresion

= max(aggr(sum(Sales), YYYYMM)

and I get the bigger sales amount grouped by month (YYYYMM); now I need a second expression to get the asociated YYYYMM value.

Please, could you help me?

Thank you

Joaquín

[jerem1234 · Accepted solution]

Maybe something like:

firstsortedvalue(YYYYMM, -aggr(sum(Sales), YYYYMM))

Hope this helps!

[Joaquin_Lazaro]

Hi jerem1234

This works fine.

Thank you