Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 30, 2017 at 09:53 AM

    Hello Stanly,

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

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 01 at 05:11 AM

    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

    Add comment
    10|10000 characters needed characters exceeded