topic Re: FirstSortedValue based on AGGR and two dimensions in App Development

FirstSortedValue based on AGGR and two dimensions

piotr-bratek — Sat, 16 Nov 2024 06:21:24 GMT

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!

Re: FirstSortedValue based on AGGR and two dimensions

crusader_ — Wed, 13 Mar 2019 01:13:25 GMT

Hi Piotr,

You were pretty close 🙂

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

PFA example.

//Andrei

Re: FirstSortedValue based on AGGR and two dimensions

NZFei — Wed, 13 Mar 2019 01:28:25 GMT

Dim1:

Product

Dim2:

Country

Measure:

if(rank(Sum(Sales))=1,
sum(Sales)
)

Uncheck "Include zero values" under Add-ons.