Iterative macro for sample selection

[peerapongt]

Hi guys,

I am trying to build an alteryx macro to keep selecting high amount records until certain criteria is met. 

In the attached example, I want untested population to be less than $15 million (Criteria) and in order to do that we need to select the first 24 invoices.

Could anyone please help?

[scottj]

I do not think this needs to iterate, but correct me if I am off on what you want.  This sounds more like a rolling sum that can be done with the Multi-Row Formula tool.

You can find some more info on Iterative Macros and the Multi-Row Formula (my favorite) Tool in these links.

See attached.

[afv2688]

Hello @peerapongt ,

For me it is the first 27 invoices