how can I do unique ranking with multiple criteria measures in BI

[Former Member]

Dear Pals,

1st Column - Depot name

2nd Column - percentage

If I do with rank formula, where ever depot name and percentage are same with the previous cell, it gives the same ranking.

Here my requirement is unique ranking with multiple criteria measures in SAP BI.

Please respond with favourable reply.

[sateesh_kumar1]

Hi Stanley,

if you are using universe ,below refer below blog .

https://blogs.sap.com/2014/02/16/dense-ranking-in-sap-business-objects-web-intelligence/ .

you can search by "Dense rank in webi" to find some more info.

Thank you

Sateesh

[Former Member]

Hello Stanly,

Can you please elaborate it lil more and if possible pls gv example with desired output.

Thanks