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

[mhmohammed]

Hi Marc,

How are you determining the rank of a Zip Code here? Are you using really using the Row Number field or do you have an Amount or Count measure?

Thanks,
Mahboob Mohammed

[Former Member]

Hi,

This is just an example I found on the net but in my case, rank function would be applied on a measure.

Thanks