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!