Skip to Content
0

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

Dec 30, 2017 at 09:16 AM

69

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

Hello Stanly,

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

Thanks

Share
10 |10000 characters needed characters left characters exceeded
Sateesh Kumar Bukkisham Jan 01 at 05:11 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded