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)
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 |