Row based calculations

[Aria_S]

Hi there,

I am trying to create a calculated column based on the below logic:

MONTH	AMOUNT	CALC. COLUMN
JAN	100	700
FEB	200	800
MAR	100	1200
JAN	400	900
FEB	300	1400
MAR	500	1000
JAN	100	100
FEB	800	800
MAR	100	100

C2 = Sum(B3:B5)

C3= Sum(B4:B6)

.

.

.

C8 = B8

C9 = B9 

and C10 = B10

Basically, I want to calculate column C such that, Jan = Feb+Mar+(next)Jan;  and so on.

Can you help me achieve this in alteryx? 

Thanks in advance.

Aria

[PhilipMannering · Accepted solution]

Hi @Aria_S 

This should do the trick,

Let me know if not,

Thanks,

Philip