cancel
Showing results for 
Search instead for 
Did you mean: 

Filter data by max date by ID

0 Kudos

Hi All,

I have a data set of HR data.

In the given table i have EmpID,PreviousCompany,StartDate,EndDate.

But for few lateral hires the rows repeat as they have worked in more than one company.

max-date.png

In sac i need to build a table story which will have one record per employee.

Attaching the screeshot for refernece.

Accepted Solutions (0)

Answers (1)

Answers (1)

IngoH
Active Contributor

Hello Praveen,

you should be able to use the LAST option from an aggregation point of view.

Regards

Ingo Hilgefort, SAP