Max

[#1]

Hello all,

I have some names of countries and I have a profit per country.

Now I want a separate text box which show in which country  I earn most profit.

How can I do that?

[Clever_Anjos]

Try

FirstSortedValue(Country, - SUM(Profit))

[MK_QSL · Accepted solution]

Or might be

FirstSortedValue(Country,  -Aggr(SUM(Profit),Country)

[#4]

Hi Lieko,

Try like this.....

Max(Aggr(sum(profit),country))

or

FirstSortedValue(Country, -sum(Profit))