Question Re: How do I implement Dense_rank function at level report? in Technology Q&A

How do I implement Dense_rank function at level report?

former_member597137 — Wed, 27 Mar 2019 17:06:38 GMT

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

Re: How do I implement Dense_rank function at level report?

mhmohammed — Wed, 27 Mar 2019 18:46:20 GMT

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

Re: How do I implement Dense_rank function at level report?

amitrathi239 — Wed, 27 Mar 2019 20:24:02 GMT

try below formula at report level.

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

Re: How do I implement Dense_rank function at level report?

former_member597137 — Thu, 28 Mar 2019 08:44:30 GMT

Hi,

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

Thanks

Re: How do I implement Dense_rank function at level report?

former_member597137 — Thu, 28 Mar 2019 08:45:11 GMT

Hi,

I tried but it doesn't work.

Do you know something about dense_rank function?

Thanks

Re: How do I implement Dense_rank function at level report?

amitrathi239 — Thu, 28 Mar 2019 09:24:08 GMT

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

Re: How do I implement Dense_rank function at level report?

former_member766485 — Tue, 14 Sep 2021 07:24:32 GMT

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?

Re: How do I implement Dense_rank function at level report?

former_member751591 — Tue, 14 Sep 2021 07:25:27 GMT

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.