How to create a running total in ETL?

poorak3
poorak3 Member
in Magic ETL

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

Comments

  • guitarhero23
    guitarhero23 Contributor

    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.


    **Make sure to like any users posts that helped you and accept the ones who solved your issue.**
  • poorak3
    poorak3 Member

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

Categories