How do I implement Dense_rank function at level report?

[#1]

Hi guys,

I want to get the same restult as the column dense_rank below : no gaps and a continuous ranking.

I read that the function dense_rank could solve this issue but this function is not available at level report among others functions.

- Is there another way to get the same result using a formula?

- How can I get this function at level report? What has to be done ? Something at universe level?

Thank you for your help!

Marc

[amitrathi239]

can you share the screenshot of data after adding variable in the table? do you have access on universe?