Alternative combination of FirstSortedValue and Group By in UI (straight table)

[Micki]

Hi folks, 

My table 

Title	Date	LAST_STATE
Title 1	1/10/2020 1:38:47 PM	None
Title 1	1/10/2020 2:38:47 PM	None
Title 1	1/10/2020 3:38:47 PM	None
Title 1	1/10/2020 4:38:47 PM	None
Title 1	1/10/2020 5:38:47 PM	None
Title 2	1/10/2020 1:38:47 PM	Passed
Title 2	1/10/2020 2:38:47 PM	Passed
Title 2	1/10/2020 3:38:47 PM	Passed
Title 2	1/10/2020 4:38:47 PM	Passed
Title 2	1/10/2020 5:38:47 PM	Passed

My expected result in UI(straight table):

Title	Date	LAST_STATE
Title 1	1/10/2020 1:38:47 PM
Title 1	1/10/2020 2:38:47 PM
Title 1	1/10/2020 3:38:47 PM
Title 1	1/10/2020 4:38:47 PM
Title 1	1/10/2020 5:38:47 PM	None
Title 2	1/10/2020 1:38:47 PM
Title 2	1/10/2020 2:38:47 PM
Title 2	1/10/2020 3:38:47 PM
Title 2	1/10/2020 4:38:47 PM
Title 2	1/10/2020 5:38:47 PM	Passed

As you see Last_State need to be group by Title and should show State where the latest Date occurs 

It's working when I have one dimension and one measures Like below, but i need to add dimensions, SO WHEN i ADD dimensions  it's stop working:

Any ideas ? 

@sunny_talwar , @Gysbert_Wassenaar , @swuehl , @petter , @kaushiknsolanki, @tresesco