We want to create reporting in People Analytics for Recruitment module.
1. Each applicants may have multiple records for Formal Education data (for example: Applicants may put both their undergraduate and graduate education).
2. The objective is that we want to only take their latest formal education data (in the case as mention in no. 1, only want to take the graduate education), in the illustration example as colored green.
3. We can determine which one is the latest formal education by "End Date (Formal Education)" field.
4. Anyone know or has ever experience things like this and know any workaround?