OBI report how to show only most recent candidate submission

Summary

In a report of all submissions for a time period, how to only show the most recent for each candidate

Content

I have a report of all submissions for the year, and some candidates apply to more than one requisition.  I would like the report to only show the most recent job submission.  There is a reporting field for most recent job offer on a submission which is helpful.  I can't find a field like that.  I tried the field "Most recent submission date" with a filter and it gave no results.  When I removed the filter and viewed the results, that field is blank on all entries.