How do I add the last absence end date from the last 5 occurrences?

Summary:

I need to report on the last absence end date on the attached report.

It is currently filtered by rolling last 52 weeks and number of absences measure of 5.

Is there a way to add the date end within Assignment Absences Details to report on just the last occurrence?

Content (please ensure you mask any confidential information):

Using the Subject Area "Workforce Management - Absence Real Time" to pick up the last absence date end for an employee using the filters mentioned above.

Or will this need a rewrite and instead of using a table using a pivot table?

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