I'm unsure of what the desired outcome will look like. Do you want to know what the max gross pay is for all employees per date?
What I keep ending up with is either a sum of all rows or the max gross pay of any employee (basically 1 attribute). I don't quite see how I get it to sum the max gross pay of each employee without displaying it as a list of employees.
Yes - you are a hero Joe. Thanks so much! I see how you did it and it's far simpler than the elaborate methods I had previously concocted (that didn't work anyway).