How to sort by a column, find the greatest value, and then find another column in that row

I’m trying to prepopulate a button. I’ve found the value by doing
[Running Total].[Amount Owed].Sort().Last()

And now that I’ve found that value I’m then trying to figure out how to grab the employee’s name in that row, but can’t figure out how to do that correctly. Any ideas?

how about:
[Running Total].filter([Amount Owed] = [Running Total].[Amount Owed].Max()).[Employee] ?

edit: thought about this, possible to break on multiples of the same amount, didn’t really test this, just off the top of my head.

1 Like

wow that worked amazingly. Thank you!