Sorry to hear that solution didn't work for you - I got the tip by submitting a service request with Oracle Support so if you have access to that you should give it a try!

Try this (I replaced your criteria with my own but you can just change what's in the quotation marks I think) MAX(CASE WHEN "Submission CSW Status - Current"."Current Step Name" IN ('Hire') THEN "Candidate Identification"."Name" END)

Kim, Thank you, thank you, thank you! I have been trying to solve this problem for a long time but couldn't even figure out step 1. I couldn't believe the first topic in the forum was exactly what I was looking for! I have not used SQL statements in my queries before so I am going to try the suggestions above first, then…