Creating two columns that use eachother

[HunterH]

Hi All. Hoping someone can help me here. I used the summary tool to create the total incoming and total closed columns. The total leftover column is calculated as [row-1:Total Accumulation] - [Total Close] ex. for month 3 total leftover = 44-20 = 24.

The problem I am having is that Total Accumulation = [Total Leftover] + [row+1:Total Incoming] ex. for month 3 Total Accumulation = 24+18 = 42

Excel is great at auto updating columns so that I can calculate these two columns simultaneously, but I am having a hard time figuring it out in Alteryx. Any help appreciated. 

Month	Total Incoming Requests	Total Closed requests	Total Leftover	Total Accumulation
1	27	6	21	39
2	18	10	29	44
3	15	20	24	42
4	18	13	29	76
5	47	16	60	68
6	8	22	46	88
7	42	41	47	70
8	23	18	52	70
9	18	35	35	48
10	13	16	32	42
11	10	8	34	45
12	11	8

Thanks - Hunter

[DiegoParker · Accepted solution]

Hi @HunterH ,

Find my approach attached.

I used a mix of formula and multi-row formulas.

Hope this helps If does, can I ask you to mark it as a solution? this will help other users to find it and will allow us to close the thread. Many thanks!

Best,
Diego

[HunterH]

This worked well, thank you. I didnt realize that when using the multi row formula tool, you could reference the new column you are creating in the expression section.