Hi All ,
How can I get the TOP 5 Claims Number who got maximum sum(GROSS_CLAIMS_PAID) with the record_source name .
If you see the sample model attached , the field names are there.
I am not getting how to show the values with record_source_name and with highest 5 claims number who got maximum claims paid .
Please kindly assist me.
Thanks in advance .
Please kindly see the sample model attached. Though I have restricted to show 5 still the table is giving value more that 5.
Please kindly see the attachment.
this will bring top 5 clime numbers
it is ur dimension
sum(GROSS_CLAIMS_PAID) as ur measure
Hi Chana ,
A claim Cannot have multiple Partners. - To answer your question
I got two dimension
1.Partner - As you mentioned - =if(aggr(rank((Sum(GROSS_CLAIMS_PAID)+Sum(GROSS_CLAIM_OUTSTANDING))),RECORD_SOURCE_NAME )<=5,RECORD_SOURCE_NAME)
2.Claim Number - As you mentioned - =if(aggr(rank((Sum(GROSS_CLAIMS_PAID)+Sum(GROSS_CLAIM_OUTSTANDING))),CLAIM_NUMBER )<=5,CLAIM_NUMBER)
Expression is - Sum(GROSS_CLAIMS_PAID)+Sum(GROSS_CLAIM_OUTSTANDING)
But still not getting top 5 claims . getting result like this -
But when selecting a particular month , it is giving me top 5 claims correct. What can be the problem. My model is huge.thus can't post. But Sample model is not showing the problem.