Candidates "Never Been Hired"

Summary

Attempting to run a report of any Candidate that Has never been hired

Content

Currently we have candidates that apply to multiple reqs, and i have attempted to build a report that exclude any Cands who do not have a current or historical submission status of "Hire". thus the issue my report is having is that it still reports out the candidates other submissions in which they have been New/Rejected on. I only want a true view of any candidate in our system that have never been hired!

 

Any help or trick to do this please advise!!! 

 

I only want 1 row per candidate.