I think that I am toast, but here is my problem:
I am a payroll company. Any given employee might work for two or more clients each week. All of those clients are paid to the employee on the same payroll check. So, Bob works for client 1234, 4567, and 8912 in the same week. All of those hours for all of those clients are paid on the same payroll check.
My payroll check print file groups by client company. Therefore, Bob's check - the exact same check - will appear in all three groups (once for each client). You can imagine the problems.
Now, I cannot change my groupings - I have to group by client for a variety of reasons. What I want to do is the following in my selection:
Add a filter that says: If a distinct check has multiple client numbers, suppress (or simply do not select) everything except the lowest value client. In other words, in the example above, ONLY select the check (or ONLY group with) for client 1234 (all clients are numerical).
Can this be done? I have tried everything and I have asked ever CR writer that I know. You are my only chance at this.