How to display Rank wise order in table in Quicksight

I want to display rank wise user by most events in quicksight but there is no options for that currently i am using dense rank function but it will not display on left side as you can’t group by this. Also is there is no row number function. Is there any solution for this problem?

Table Image

Currently there is no way to do this in QuickSight.

I would suggest moving these calculations to SQL if you can. Then you will be able to do all that you want.