Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Discussions

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

Aggregate prior row data and show in an another column.

7 - Meteor



I am trying to sum values from each preceding row and show the running total in an additional column



Year    Amount    Total

2000      100         100

2001      150         250

2002      200         450

2003      100         550

2004      175         725


Target is to auto generate the Total column when Year and Amount are given.  I am able to do this using Multi-Row Formula tool, but the I have to hard code the expression based on number of records (5 in this case).  There has to be a way to automate this. Meaning the Total get dynamically generated instead of me changing the expression every time the records count changes.  Need some advice.  Thank you

16 - Nebula
16 - Nebula

Hi @Spatel68 the running total tool might help you in this case. You can also make the expression in the Multi-Row tool dynamic. See the attached workflow where I mocked up a couple of examples. 

7 - Meteor

Thank you Joseph Serpis