assistance required in expression to show top rsultsin text object of chart ?

[ashmitp869]

Hi there, 

Please kindly assist me with the expression , I want achieve the most "Episode Speciality on separation" shown as text at top of the chart, as you see there are two "Dental Surgery" and "Emergency Medicine" result thus my expression is not working.

Here is my expression - =FirstSortedValue(Concat(DISTINCT [Episode Specialty on Separation], ','), [Episode Specialty on Separation] ,-Aggr(Sum([ETP Numerator])/Sum([ETP Denominator]), [Episode Specialty on Separation]))

Please suggest.

Thanks in advance

[MayilVahanan · Accepted solution]

Hi

Try like below

=Concat(Distinct Aggr(if(Rank(Sum([ETP Numerator])/Sum([ETP Denominator]))=1, [Episode Specialty on Separation]), [Episode Specialty on Separation]), ',')