Firstsortedvalue

[GeorgePhilips23]

I have 3 fields: Sum(revenue), Product  and Month(Jun and Jul only)

Now I have to find highest revenue generating Product in the month of Jul.

Can anyone help me out with an expression for the same?

[anat · Accepted solution]

=FirstSortedValue(Product, -Aggr(Sum({<Month={'July'}>}Sales), Product))

[GeorgePhilips23]

THanks a lot @anat !