Rank for Company

[rkpatelqlikview]

Hi All,

Its very urgent for me.

How to give the rank to the Company based on their performance %.

If 2 companies having the same % then it should compare with their no of branches.

          Company  Brancehs    KPI%     Rank

           ABC          3                55%         3

           DEF          6                55%         2

           GHI            2                75%          1

            JKL            8                45%         4

If select any company "ABC", Rank is -> 3/4.  

Please can any one help on this. Thanks in advance

[qliksus]

Maybe something like the below

IF( FINDONEOF(RANK(SUM(KPI%)),'-')>0,RANK(SUM(Brancehs)) ,RANK(SUM(KPI%)))

[jerryyang756]

Thanks & Nice. A little correction. You have to calculate the Rank on Total

IF( FINDONEOF(RANK(TOTAL SUM(KPI%)),'-')>0,RANK(TOTAL SUM(Brancehs)) ,RANK(TOTAL SUM(KPI%)))

[rkpatelqlikview]

Thanks response. Please find the attached sample data. I tried with this formula.

I'm unable to see the result.

[rkpatelqlikview]

Thanks for your response Pritam

[rkpatelqlikview]

Thanks for your reply Susant

[Qrishna]

psa

[rkpatelqlikview]

Many Thanks for your help Krishna. Excellent, But when am implementing on this attached data its not working.

[jerryyang756]

I have used it on your sample data. Please check it If the sorting is correct or not.

[rkpatelqlikview]

Thanks Pritam,

Yes, Correct one.If the % is same then it should count the trucks like below. Sum(Measure) is 100 and a100 for two carriers at that situation we can give the rank based on the no.of Trucks. at that time first one is Rank2, next one is Rank1.

I need to show this in the two text objects one for  current rank and another for Previous rank.

Thanks

KUMAR