About EasyMorph Tutorials & Examples Web-help

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