The method involving creating a new column containing the MAX function to compare against, produced null values for some rows and is clunky in comparison to using the max function directly in the filter, it is similar to the ROWNUMBER() over partition method when in SQL

I managed to solve the problem by applying a filter using the MAX function : "Person Work Permit"."Expiration Date" = MAX("Person Work Permit"."Expiration Date" by "Person Details"."Person Number") on the Expiration Date field

Hi MandeepGupta Thanks for responding I have an OTBI report that is returning rows containing the "Person Details.Employee Number" and "Person Work Permit.Expiration Date" from the WFM- Person Real Time subject area. I need to be able to return a single row for each person that contains the latest expiry date. I have seen…