About EasyMorph Tutorials & Examples Web-help

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.