Similar function like FIRST SORTED VALUE()

[aathi33]

Hello Guys,

I'm searching for the similar function like FIRST SORTED VALUE().

To fulfil my condition

I need to find name of customer who has maximum sales across the region

Using if condition:

=if(aggr(rank(sum(Sales)),region,Customer)=1,Customer)

Using first sorted value:

(I can get these values when the conditions are applied)

But I need the without any filter and both customer for the two region must be shown on the table.

[BrunPierre]

Hi, like this perhaps?

=Concat(If(Aggr(Rank(Sum(Sales)),Customer,Region)=1,Customer & chr(10)))