Filter and DIstinct Rows

(0) Share

Report

Posted on by Revl0ck97

I have a query that needs to be filtered by farthest date and then distinct per email and I am really having trouble whether If conditions are possible in filtering rows? Thank you in advance for any help.

All responses (1)

Answers (0)

Revl0ck97 44 on at

Like (0)

Report

Re: Filter and DIstinct Rows

hello @Syndicate_Admin

So the filtering I need to achieve is a bit tricky since there are multiple criteria, firstly the expected result should be distinct emails which beforehand is selected like a lookup where the record with the highest Units is chosen AND if there are multiple emails with the same highest ratio, select the one with the highest Date.
Expected Result: