Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
You should add the CLAIM_NUMBER dimension and put the dimension limit to the CLAIM_NUMBER not the RECORD_SOURCE_NAME.
Hi ,
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.
=If(Aggr(Rank(Sum(GROSS_CLAIMS_PAID)),CLAIM_NUMBER)<=5,CLAIM_NUMBER)
this will bring top 5 clime numbers
it is ur dimension
sum(GROSS_CLAIMS_PAID) as ur measure
one claim has multiple partners you need to think which one you want to show
if you want to show top 5 after adding partner you need to change expression
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.
i dont find this measure in qvf
GROSS_CLAIM_OUTSTANDING