expression to display just highest value on a table

[sweens78]

Hi guys I want a do a table where the

Dimension is called 'hospital '

Expression=   

'Count(NEWKEYID)-Count(PatientsNotAssessed_ID)'

What expression can I use just to display the highest value on the table

[lblumenfeld · Accepted solution]

If you want to show this in a Text Object (or other object) outside the table then 

Max(Aggr(Count(NEWKEYID)-Count(PatientsNotAssessed_ID), Hospital))

should work. This will give you the maximum value of the formula calculated by Hospital.