Top N sales within categories


If I use the rank (Cumulative Sum transformation) based on sales to find the Top N within categories, the rank 1 is affected to the lowest value. I want 1 to be the greatest one.
I created a “Minus Sales” Column = (0-1) * Sales and apply the rank transformation on it.
Is there an other solution ?

Best, Michel

There’s the Rank Descending mode in the Running Total transformation. That should do it.

Oh Sorry, I didn’t see it.

Even if it’s in Wikipedia, I would have liked some more details in the documentation about the ranking:

  • Standard competition ranking (“1224” ranking)
  • Dense ranking (“1223” ranking)