Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I get of the name of maximum value
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))
This can be done by FirstSortedValue.Please find the application file
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))
thank you