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...
  • kk_shp_user's avatar
    kk_shp_user
    2 years ago

    I was able to solve this using ROWNUMBER()

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

I was able to solve this using ROWNUMBER()

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.