Ranking is not being applied correctly

[Former Member]

Hi SAP dashboards community,

I've been trying to apply a ranking to a table with the next 3 columns:

     Payment type: first dimension in the table

     Days between: days calculated by a formula, but it was set as a dimension

     D/C : debit / credit ratio

What I want to achieve is the 3 greatest D/C amounts for each "Payment type" regardless of the "Days between" dimension.

What I get is the 3 greatest D/C amounts for the first Payment type, and for the rest I get the ones which match with the same "Days between" dimension

Please take a look at the attached image.

Notice that the different "D/C" amounts correspond to the different "Days between". Without the "Days between", I have only one D/C for each payment type.

I appreciate your help .

Liliana

[harshil_joshi · Accepted solution]

Dear Liliana,

As per your explanation, I made a webi report based on excel sheet

Now Make a variable named Rank=Rank([D/C];Top;[Payment Type])

Thanks & Regards.

[Former Member · Accepted solution]

This was exactly what I needed. I created the Rank variable and used it as  a filter. I was looking for this solution for days...

I'm sorry I cannot mark both Harshil and Amr responses as "Correct" since I used a combination of both. I marked Harshil's one as correct because of the helpful screens.

Thanks a lot!

Liliana

[amrsalem1983]

Hi Liliana,

Actually What you need to do is to create a new variable dimenstion called Ranking_D/C

=Rank([Value];([Year];[Department]);([Year]))

then you can use this Ranking Variable as a filter to restrict to top 5

Regards

Amr

[Former Member]

Hi,

Use the "Payment Type" dimension in the Ranked by Drop down.

Update the discussion if your are looking for something else.

Thanks