How to get top five with the highest rank?

[kristeljoymalapitan]

Good Day,

How can I get the top 5 Region with the highest outstanding balance percentage per month in a line graph, please see below sample screenshot

I use this measure  : SUM({<[CLASSIFICATION] = {'PD','LEGAL'}>}[outstanding_bal])/(SUM({<[CLASSIFICATION = {'PD','LEGAL','REGULAR'}]>}[outstanding_bal])

Thank you

[kristeljoymalapitan]

Hi Sunny_talwar,

How about to get the Top 5 with the highest number of Non Starter accounts per month and  per Dealer,

Please see below expression used.

AGGR(

IF(RANK(COUNT(){<[NON_STARTER] = {'YES'}>[ACCOUNTNUMBER]))<6,COUNT({<[NON_STARTER] = {'YES'}>}[ACCOUNTNUMBER])),

MONTHYEAR,DEALER)

[sunny_talwar]

May be this

Aggr(

If(Rank(Count({<[NON_STARTER] = {'YES'}>} [ACCOUNTNUMBER])) < 6, Count({<[NON_STARTER] = {'YES'}>} [ACCOUNTNUMBER])),

MONTHYEAR, DEALER)