Top 5 claims across for the claim_registered across all brokers ?

[suvechha_b]

Hi All,

How to get top 5 claims across for the claim_registered across all brokers in the sample model attached.

Please check Brokers Report and Top 5 Claims by Value.

Thanks,

[sagarjagga]

may be you can try below expression .
if(aggr(rank(sum(Gross)),Broker)<=5,ClaiimNumber)

[suvechha_b]

Hi,

I used you expression - but still not working. I got 7 claims and I did top 10 but it is not showing all the seven. please kindly assist . model attached.