How do I implement Dense_rank function at level report?

[former_member597137]

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

[former_member766485]

Is there still any solution to the above problem? How to achieve ranking of values without any rank being skipped on getting ties between same values?

[former_member751591]

Thanks for coming to SAP Community for answers. Please post your question as a new question here:

Since you're new in asking questions here, check out our tutorial about asking and answering questions (if you haven't already), as it provides tips for preparing questions more effectively, that draw responses from our members.

Please note, that your post here won't be answered.

[amitrathi239]

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

[amitrathi239]

try below formula at report level.

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

[former_member597137]

Hi,

I tried but it doesn't work.

Do you know something about dense_rank function?

Thanks

[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_member597137]

Hi,

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

Thanks