How to put rank function to dimension

how to put rank function to dimension not in value calculation in qs pivot table visual type.

i need to calculate top n insurance groups by total amount we received in past 10 month. But the current calculation I did cannot move to dimension. Could you provide the calculation we can move to dimension?

Each column is month 1,2,3…
Each row is top insurance group aaa,bbb,…
I want to add rank on the left of insurance group

1 Like

Hello @Yingkang_zhou, are you able to share an anonymized screenshot of the pivot table you are building and the calculated field you created for rank? If you want to display it before the insurance group, you should be able to add it into the row field well and then you might want to go into the pivot options and switch your display to tabular. Let me know if that helps, otherwise if you provide some of the screen captures I suggested, I can guide you further.

PivotOptions

Hello @Yingkang_zhou, I wanted to check in and see if my above response helped guide you towards your expected output. Feel free to mark my reply as the solution, otherwise let me know what issues you continue to face and I can guide you further. If we do not hear back from you in 3 days, I will archive this topic. Thank you!

Hello @Yingkang_zhou, since we have not heard back from you with any follow-up information, I will archive this topic. If you still need assistance with this issue, please post a new topic in the community and link to this question. That will ensure you will be at the top of the priority list for a response from one of our QuickSight experts. Thank you!