Reverse Running Total

[Adam_P]

Apologies for what I am sure is a easy question (that I can't seem to find an answer to).

I am looking to do a "reverse" running total in Alteryyx.  I have a series of cashflows per month and need to sum the future cashflows for each particular month to obtain a balance outstanding.

Anyone have any suggestions as to how to calculate the Total Cumulative Sum in the table below.

Month	Monthly Cashflow	Total Cumulative Sum
Jan-19	100	1200
Feb-19	100	1100
Mar-19	100	1000
Apr-19	100	900
May-19	100	800
Jun-19	100	700
Jul-19	100	600
Aug-19	100	500
Sep-19	100	400
Oct-19	100	300
Nov-19	100	200
Dec-19	100	100

[OllieClarke · Accepted solution]

Hi @Adam_P this is the easiest way of doing that I could think of

Let me know if that helps,

Ollie

[Adam_P]

Perfect.  Thanks for that.

[Brian_S]

Not sure of the requirement if the monthly totals vary -- the attached takes care of that.