Ranking Decile

Question

Decile (from 1 to 10) of the order number based on «Ranking» value.

If multiple order number with same ranking need to split between different deciles, then order line with earliest «DATE» gets higher decile.

Please help.......

Sample DATA.xlsx

TimN · Answer

Try the tile tool.  There are options - "Equal Sum", etc.  I attach an example.

Tile.yxmd

kunalswami · Answer

Want to create a new col Decile based on ranking

gautiergodard · Answer

Hey @kunalswami

Can you do something like this?

New Workflow5.yxmd