FirstSortedValue based on AGGR and two dimensions

[piotr-bratek]

Hi Guys,

the situation is as presented below. On the left source data, on the right - what I'm trying to get. Important! I want to calculate it in a table on a sheet.

What I've tried is presented below but the FSV function returns incorrect results. Can you pls advice where is the mistake?

QVF is attached.

Thanks!

[dplr-rn]

Change your expression to

firstsortedvalue(Country, -aggr(max(Sales), Product,Country))

that should give you the correct answr