cancel
Showing results for 
Search instead for 
Did you mean: 

Dense Ranking with out repeating Rank in WEBI

sudhasahi
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

sudhasahi
Explorer
0 Kudos

It don't work .

sudhasahi
Explorer
0 Kudos

Thank you ,but it not working for my data.

sudhasahi
Explorer
0 Kudos

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
Active Contributor
0 Kudos
sudhasahi
Explorer
0 Kudos

Thank you ,but its not working for my data .