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]

try below formula at report level.

=RunningCount([Zip Code]) In([Zip Code])

[Former Member]

Hi,

I tried but it doesn't work.

Do you know something about dense_rank function?

Thanks