Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Iterative macro for sample selection

5 - Atom

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?


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.

Scott Jones
Strategic Sales Engineer
Alteryx, Inc.
Alteryx Certified Partner
Alteryx Certified Partner

Hello @peerapongt ,


For me it is the first 27 invoices