Forum Discussion

kk_shp_user's avatar
kk_shp_user
Icon for Helper I rankHelper I
2 years ago
Solved

Rank/ TOPN based on two columns

I have a table like below and want to populate the rank column shown.

 

I want it to be based on count DESC, total DESC. I tried searching online on how to solve this without any success. This does not sound too complex but then I'm surprised there are not a bunch of questions around this.

 

Any help would be grteatly appreciated.

 

 

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi kk_shp_user 


      Congratulations!
      I'm sure there are quite a few people who have been confused by this question.
      Thank you very much for sharing.

       

      Best Regards

      Zhengdong Xu
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.