how to exract client classification for max datekey .
Hi all,
i have a scenario that need to pick client clasification for latest datekey. for example if you see below table some of the columns we have this i am using filters as "master client" ,Client classificatio"..... so if i select "masterclient" as AAA it has to pick latest "date key " client clasification as Diamond , but now if i select AAA it is showing as Diamond and funded both . so how to achive this 1-1 mapping should be there for master client and client classfication. if we have more client classification for 1 master client also it has to pick only one master client based ok the max(datekey)
