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
Solved! Go to Solution.