need to display client classification based on latest date key

[vanir88]

Hi All,

i have a requirment link in filter if select master client it has to show the client classification valuse based on latest date key.
for example below is the data i have filters like , master client, client classification, master number,.....etc 
now if i select value  AAA based on latest datekey(29-08-2023) client classification has to display Diamond.

here one master client- one client classificatio means(1-1), how to achive this

datekey	master client	client classification	master number	contact Number
29-08-2023	AAA	diamond	1000500653	876548984
25-08-2022	AAA	Funded	1000500653	876548983
10-07-2023	AAA	Diamond	1000500653	876548984
29-08-2023	AAA	Diamond	1000500653	876548984