Stratify and select top 85% of a population

[wpaschal]

Hello Knimers!!

I’ve got another challenge to solve… we’ve been asked to select all transactions in a population whose amounts represent the top 85% of the total population balance. In other words…

Sort population by amount, largest to smallest. Then select all transactions starting at the top until the running balance hits 85% of the total.

There are probably 10 different ways to go about it, so putting it to the group for recommendations.

Thanks in advance!

[HansS]

Hi @wpaschal

I’m thinking of something like this: select_top85.knwf (89.2 KB)

gr. Hans

[wpaschal]

Whoa, that’s it!!

Hopefully we can find each other one day so I can buy you a beer