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!

Iterative Macro

Accepted answers

MichalM

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

All comments

MichalM

@AmyL1

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?

MichalM

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703