Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Piotr,
You were pretty close 🙂
firstsortedvalue(Country, -aggr(max(Sales), Product,Country))
PFA example.
//Andrei
Dim1:
Product
Dim2:
Country
Measure:
if(rank(Sum(Sales))=1,
sum(Sales)
)
Uncheck "Include zero values" under Add-ons.