Top N sales within categories

1

Hi,

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

3

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

4

Oh Sorry, I didn’t see it.
Thanks

5

Hi,
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)
6

Done: http://help.easymorph.com/doku.php?id=transformations:runningtotal