How to accumulate numbers from largest to smallest

Junichi

Sample data.xlsx

Uploaded Jan 6, 202514.01 KB

As sample data shows, the data has customer ID column and revenue by customer column, and I would like to accumulate the revenue from largest revenue to smallest revenue to identify which customers are in top80% market and which customers are in bottom 20%. How can I calculate like orange-colored column in DSS?

Junichi

In addition, I cannot use physon, so I would like to know how to do it with reciepe function.

Alexandru

Hi @Junichi ,

You should be able to use a Window recipe to accumulate and sort the revenue:
https://knowledge.dataiku.com/latest/data-preparation/visual-recipes/concept-window-recipe.html

Then you would have the sum and rank and based on the rank you can determine your top %