How to create a running total in ETL?

How can add a number from the previous month in the ETL?


  • What's the schema of your data like? Is it 1 row per month? Might help people understand further if they knew if data was already grouped by month or if you would have to do some grouping first.

  • The data is already grouped by month. Just need a running total of the Fiscal Year.