Employee job levels

Summary:

Adding job level to employee report

Content (please ensure you mask any confidential information):

We have a requirement to show the employee job levels. When I add the job level field it duplicates records and show the old job levels assigned to employee. I couldn't find a field to filter only to show the latest job level assigned in the employee assignment.

Has anyone done a similar report?

Version (include the version you are using, if applicable):

24C

Code Snippet (add any code snippets that support your topic, if applicable):