260776.qvw 152.0 K
your answer is the "correct".
his answer is not the right one, it was how i approached the problem too but it doesnt work.
your answer tho is genius, it took me while to understand how come the firstsortedvalue function works here
but once i realised how, it hit me how simply great is your approach
what was baffling to me was that "FirstSortedValue" returens a null if the highest number appears in more then 1 row.
but since your using it on an aggregation, that insures there will never be to values the same the top.