Get Value of the upper Ranking

[maxime66]

Hy Qlikers,

I try to find a solution ( without script) to get the upper value in a list.

In my exemple attached, i would like to calculate (in last column) the sales amount that is missinf to reach one rank.

dylan >  2 $ to reach 3rd place

marc > 5 $ to reach 2nd place

jon > 5 $ to reach the first place

Thank you for your help 😉