Filter Till desirable SUM is met

[arods]

So if anyone could help me with this problem i wold appreciate a lot.

So let´s suppose i have three columns product and qty, then I add a Record ID because the order of my products matter

I want alteryx to output to me the recods till the SUM of the column qty is equal to 40

The input would be something like the first pic and the output the second one.

[apathetichell · Accepted solution]

use running total. group as needed. use filter.

[griffinwelsh · Accepted solution]

@arods Here is a solution workflow. This is the method that @apathetichell described.

[arods]

Thank you, that was it!