Select rows within a group that match a condition

[yatish1164]

Data:

I have this problem where I only want to pick rows from a "group" where the "% of total" for those rows is greater than 75%.

For example: (the data is sorted by group first and then % of Total in Descending order so that I can pick the highest % first)

In group one, Alteryx should only consider Apple and Google since together they are more than 75% and ignore Meta for group 1.

For group 2, it should take apple, google, Meta and Amazon.

Any help is highly appreciated

[r_manju02 · Accepted solution]

Hi,

You can make use of Running Total and Multi-row formula (refer attached workflow).

[yatish1164]

Thank you @r_manju02 🙂 Very smart trick!