Need help to display a value using a text object

[#1]

I'm looking for help in the expression of a text object. How can I do a sum of a field and they display the text of the filed with the highest sum?

ex. Chrome     5,000

     Chrome     3,000

     IE              1,500

     Chrome     1,800

     IE              2,200

     IE               900

If we sum the values, Chrome has the highest sum and then I want the value of Chrome to be displayed as the text object. Can someone help me with the expression?

Thanks,

[sunny_talwar]

May be like this

Max(Aggr(Sum(Value), FieldName))

[#3]

Thanks, it provides the count, but not the field name for some reason.

[Peter_Cammaert · Accepted solution]

Or

=FirstSortedValue(BrowserName, -Aggr(Sum(Value), BrowserName))

[sunny_talwar]

Look at Peter's response below....

I thought you said you wanted the value of Chrome

[#6]

Thanks, worked perfect.