Skip to Content
Former Member
May 13, 2013 at 11:45 PM

Ranking is not being applied correctly


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 😊.