Firstsortedvalue

[rustyfishbones]

Hi All,

I have the following expression that should return the name of the Bowler with the most wickets taken, however 2 Bowlers have the same amount, how can I show both names as the shared top Wicket taker

='Leading Wkt Taker '& chr(13) &

FirstSortedValue(Bowler,-Aggr(SUM(Wickets),Bowler))

& ' ' & MAX(AGGR(SUM(Wickets),Bowler))

[marcus_sommer]

Maybe you could integrate rank() or/and concat() in your firstsortedvalue-expression.

- Marcus

[#3]

You may need to add nodistinct to your aggr functions. Aggr(nodistinct SUM(Wickets),Bowler))

[rustyfishbones]

I tried that, no luck....

[tresesco]

Load * Inline [

Dim, Amt

A, 100

B, 100

C, 99

D, 98]

=FirstSortedValue( Aggr(Concat(Dim,','),Amt),-Aggr(Amt,Amt))

Gives - A,B

[rustyfishbones]

Tried it with Rank and Concat, but I could not get it working

[jerem1234 · Accepted solution]

Maybe:

concat({<Bowler = {'=rank(sum(Wickets))=1'}>}distinct Bowler, ',')

Hope this helps!

[rustyfishbones]

Thanks this worked!