How to get the last assignment if the worker have several records in a Analysis and Report (Goals)

How to get the last assignment if the worker has several records in an Analysis and Report (Goals). We need to get the last assignment considering their last assignment approving manager and/or line manager of the employee.

Content (please ensure you mask any confidential information):

Hi @everyone,
We need a report to get the last assignment if the worker has several records in the Analysis and Report (Goals). Example: In the image, if we have 5 records, we want to get only 1 row with the most recent assignment of the employee. Thanks and Regards