Report to view employees currently on redeployment

Summary

How to exclude employees from a redeployment report if they have been successfully redeployed into a new role

Content

I need a report that displays all employees currently on redeployment.

To do this I created a report that displays all employees with a 'redeployment end' assignment line.

The issue is that employees that have been successfully redeployed still remain in that report, as the redeployment end assignment line will still exist.

To resolve this issue I need a filter that excludes employees with a redeployment end assignment line - if they have a more recent assignment line that supersedes it.