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

[rkpatelqlikview]

It is correct one. Thanks Pritam,

Can you please help me to understand this.

This is the expression for KPI %

=rangesum((Ceil(SUM({<[Control_Fleet (Y/N)]={'Yes'}>}Quantity)/SUM({<[Control_Fleet (Y/N)]={'Yes'}+{'No'}>}Quantity)*100,0.01,0) /4)

+

(Ceil(SUM({<[iVMS ( Y/N)]={'Yes'}>}Quantity)/SUM({<[iVMS ( Y/N)]={'Yes'}+{'No'}>}Quantity)*100,0.1,0)/4 )

+

(ceil(sum({<[Safe KM driven Classification]={'Green'}>} [Kms Travelled])/sum([Kms Travelled]) *100,0.1,0) /4 )

+

(round((Count(DISTINCT [Vehicle Number]) - Count(DISTINCT {<Status1 = {"$(='>=' & Date(Today() - 7))"}>} [Vehicle Number]))/Count (DISTINCT [Vehicle Number]) *100, 0.01,0)/4)).

How can i write below statement by using the above KPI???

=Aggr(rank(Sum( KPI% ) +  [Vehicle Number],1), [Carrier Name]).

Thanks again for your support.