I've been struggling with analytical functions in my saved search. What I want to see is the email address with the lowest job level. Both are field values in the employee record so a group won't work since then I will get the lowest job level for multiple email addresses.
It seems like a very simple question but I can't seem to find the right criteria to use