Ranking using multiple criterion

Hi All,

I have a sales data which has a team manager , team managers will have no.of sales rep. the reps will sell different products ma,hv,hg, others (Revenue)

conditions:

product ma is given more importance, hence those team managers who have reps selling more Ma should be ranked1st but the same team manager can also have reps selling hv,hg &others in that case those reps should also come as they report to the same manager but ranked below the reps who sell more me.

hence all the team managers who have reps selling ME is ranked & your left with team manager who have the remaining 3 products alone in that case ranks is 2nd hv 3rd hg & last others

there will be team mangers who do not have reps containing hv nor hv nor me but only other then others should be so ranked highest


ranking: 1st because he has 4 me contributing to the revenue

team mangerA , rep1 ,rank1 me,
team mangerA , rep2 ,rank1 me,
team mangerA , rep2 ,rank1 me,
team mangerA , rep2 ,rank1 me,
team mangerA , rep3 ,rank2 hv,
team mangerA , rep1 ,rank4 others

Followed by 2 nd because he has 2 me contributing to the revenue

team mangerb , rep1 ,rank1 me,
team mangerb , rep2 ,rank1 me,
team mangerb , rep3 ,rank2 hv,
team mangerb , rep1 ,rank4 others

Followed by 3 nd because he has 2 hv contributing to the revenue


team mangerc , rep1 ,rank1 hv,
team mangerc , rep2 ,rank1 hv,
team mangerc , rep3 ,rank2 others

Followed by 4th because he has 1 hv contributing to the revenue


team manger D , rep1 ,rank1 hv,
team manger D, rep2 ,rank2 others

Followed by 5th because he has 3other contributing to the revenue


team manger d , rep1 ,rank1 others,
team manger d , rep2 ,rank2 others,
team manger d , rep3 ,rank3 others


Attached is sample data kindly help me with this multiple ranking

Regards
Gamefreak
Followed by 6th because he has 2other contributing to the revenue


team manger e , rep1 ,rank1 others,
team manger e , rep2 ,rank2 others,