First Sorted Value

[Prabhu1204]

Hello,

I am really stuck on the  logic.. I tried first sorted value and it does seems to work.. for some ID the value is blank

I want to get the latest status for the each ID, 

Logic for fetching the latest status is : Firstly it has to take the maximum end date and then Maximum task order ( there might be the cases where the maximum end date can be more than 1 ). Please find below the sample input and output.

Sample Input
ID	Status	Task	End Date	Phase	Task Order
A123	Competed	1	7/29/2022	Review	1
A123	Competed	2	7/30/2022	Approval	2
B123	Completed	3	6/29/2022	Review	1
B123	Completed	4	6/30/2022	Approval	2
B123	Completed	5	7/1/2022	Finalize	3
B123	Completed	6	7/2/2022	Close	4
C123	Completed	7	5/29/2022	Review	1
C123	Completed	7	5/31/2022	Approval	3
C123	Completed	7	5/31/2022	Close	4
Expected Output
ID	Status	Task	End Date	Phase	Task Order	Latest status
A123	Competed	2	7/30/2022	Approval	2	Approval
B123	Completed	6	7/2/2022	Close	4	Close
C123	Completed	7	5/31/2022	Close	4	Close

[Prabhu1204]

if you can tel me the expression to be used in set analysis i would try that