hiii
my table
| Max_date | clm_no |
| 20-05-2016 | RC-HS16-10352928 |
| 15-03-2016 | RC-HS15-10342240 |
| 13-04-2016 | RC-HS16-10346883 |
| 14-11-2015 | RC-HS15-10322714 |
| 26-04-2016 | RC-HS16-10348822 |
| 20-05-2016 | RC-HS16-10352928 |
| 20-05-2016 | RC-HS16-10352928 |
| 20-05-2016 | - |
this is my code for getting clm_no :
=FirstSortedValue(CLM_XGEN_CLAIM_NUM,-aggr(Max(if(len(KeepChar(CLM_XGEN_CLAIM_NUM,'-'))<>3,(CLM_INTIMATION_DATE))),
POL_BDM_CODE,POL_BDM_NAME,HOSPITAL_CODE,HOSPITAL_NAME,CLM_INTIMATION_DATE,CLM_XGEN_CLAIM_NUM,ICD_CODE_LEVEL1_org))
in this second coulmn last field is coming blank
in this i want max date with its clm_no but max_date is coming but clm_no is not coming
there are there 3 time same max_date and same 3 time same clm_no in this table
so i want this output in table :
| Max_date | clm_no |
| 20-05-2016 | RC-HS16-10352928 |
| 15-03-2016 | RC-HS15-10342240 |
| 13-04-2016 | RC-HS16-10346883 |
| 14-11-2015 | RC-HS15-10322714 |
| 26-04-2016 | RC-HS16-10348822 |
| 20-05-2016 | RC-HS16-10352928 |
| 20-05-2016 | RC-HS16-10352928 |
| 20-05-2016 | RC-HS16-10352928 |
so pls help me in this its on urgent basics
