Top entry inside Text box

[JoseGarcia]

Hi there, 
Can anyone assist with the following:

I have a table with some values results. I would like the highest value to be displayed inside a text box or numeric KPI.

  
any ideas?

These details should be in the text box/ KPI.

Thanks a million.

[sunny_talwar · Accepted solution]

Try this

FirstSortedValue([CC$.cause_code], -Aggr(Count([CC$.cause_code]), [CC$.cause_code]))

[JoseGarcia]

Sunny Talwar, 

spot on! Thanks a million.