OBI report how to show only most recent candidate submission
SummaryIn a report of all submissions for a time period, how to only show the most recent for each candidate
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.