Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!

How to do an iterative sum in Alteryx?


I am fairly new to Alteryx, but I am trying to figure out how to mimic a for-loop using some sort of iteration tool in Alteryx. Currently, I have a data set where I have a balance column and a date column, and the dates range from June 2014 to June 2019. I want to know the sum of the balance column between June 2014-June 2015, July 2014-July 2015, August 2014-August 2015 etc. until I reach my final sum between June 2018-June 2019.


Is there an easy way to do this? Any help is appreciated here!




Would it be a 12-month rolling window?  So for the period June 2014-June 2015 you'd want to sum up values from June 2014-May 2015 or include June 2015 as well making it 13 months? 


Either way, I've found a post with a very similar problem here. The easiest way to solve this would be to use one of the CReW Macros called Moving Summarize - you can download the whole pack here.


This is how it looks like




Thank you so much! This is exactly what I was looking for