Name of maximum value

[#1]

How can I get of the name of maximum value

[#2]

This can be done by FirstSortedValue.Please find the application file

[simenkg · Accepted solution]

Are you not sorting by the individual values of Value? If you sort the individual values from biggest to lowest they are the same as doing it for sums of values. I think a correct way to do it is to use the expressions:

max:

=FirstSortedValue(Name,-aggr(sum(Value),Name))

and

min:

=FirstSortedValue(Name,aggr(sum(Value),Name))

[#4]

thank you