Hi,

I'm having a bit of trouble doing a search or sort. I'm not sure what the best way to go about this task is since I've never done it before.

Basically, I want to filter this table to show the record with the highest value from a subset of the table.

For example, if I had a table with salespeople and their sales that they've made throughout the year, and showing what product

Employee Sale Amount Product
Alice 100 X
Bob 200 X
Charlie 250 Y
Alice 200 Z
Alice 500 X
Bob 100 Y
Alice 400 X
Charlie 200 Z

I want to be able to filter it so that it only shows the record for each employees top sale,

So it would show

Employee Sale Amount Product
Bob 200 X
Charlie 250 Y
Alice 500 X

I've thought about making another column to return a true or false value based on whether that sale is the employees highest sale amount, and then filtering from there, but I don't know how to go about that either.

Thanks for any help!

-Trevor