order your table by ID and P_YEAR than use peek() or previous()
Please refer to:
Thank you for your response..
The problem is that I need to add filter to the table, Year = Max(Year) , so only the records of 2017 will remain:
ID P_Year P_Status P_Last_Status 11 2017 Good Failure 22 2017 Success Good
In your solution when I added the filter I got no value in field P_Last_Status..
Could you please advise?