Dense Ranking with out repeating Rank in WEBI

[sudhasahi]

Hello All,

I have a table with the Date, Country, and volume. I have to Rank them based on the Volume I am getting the same Rank due to the size of the volume. I have to achieve the dense rank function at report level where Volumn is variable column . Please advise.

Sample Data.

Date Country Volume Rank

12/2/2023 USA 3 3

12/5/2023 USA 5 1

12/6/2023 USA 3 3

12/8/2023 USA 3 3

12/9/2023 USA 5 1

12/12/2023 USA 2 7

12/13/2023 USA 3 3

Expected Result :

Date Country Volume Rank

12/2/2023 USA 3 3

12/5/2023 USA 5 1

12/6/2023 USA 3 4

12/8/2023 USA 3 5

12/9/2023 USA 5 2

12/12/2023 USA 2 7

12/13/2023 USA 3 6

[sudhasahi]

It don't work .

[sudhasahi]

Thank you ,but it not working for my data.

[sudhasahi]

I have tried. Running count on Rank. It didn't work for me.

The rank should be repeating. Trying to achieve the dense rank.

[amitrathi239]

check below thread.

https://answers.sap.com/questions/12859993/top-10-even-if-there-are-duplicate-values-in-webi-.html

[sudhasahi]

Thank you ,but its not working for my data .