Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.

Alteryx Designer Desktop Discussions

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

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?

Alteryx Alumni (Retired)

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.
16 - Nebula
16 - Nebula

Hello @peerapongt ,


For me it is the first 27 invoices