More than 1 matching value with FirstSortedValue

[#1]

My data is like this.

game:

load * inline

[

player, wkts

a, 20

b,30

c,20

d,30

e,41

f,41

];

Have a text box with this expression:

=FirstSortedValue(distinct player,-[wkts])

I get to see only Player 'e', where i want to see both e and f. Can you help please.

[hic · Accepted solution]

Use this instead:

=Concat(distinct if(wkts=Max(total wkts),player),', ')

HIC

[#3]

That is perfect.