4 Replies Latest reply on Jul 23, 2018 6:08 AM by Zoerab Zakrijev

    Running_SUM per month, restarting per year

    Zoerab Zakrijev

      Hi guys,

       

      I am trying to calculate a running total per months for my area chart, which I do by using running_sum, but here's where I have a challenge, I need it to restart every year.
      If my graph is showing data monthly, I can't edit table calculation to be restarting by year. Any ideas how I can achieve this, maybe using LOD or some other way around? Thank you very much.

       


      Example:                                              Running Sum

       

      Jan 2017 - 50 units                              Jan 2017 - 50 units    
      Feb 2017 - 60 units                              Feb 2017 - 110 units
      Mar 2017 - 50 units                              Mar 2017 - 160 units
      .                                                            .    
      .                                                            .
      .                                                            .
      Dec 2017 - 20 units                              Dec 2017 - 200 units

      Jan 2018 - 10 units                              Jan 2018 - 10 units   
      Feb 2018 - 20 units                              Feb 2018 - 30 units
      Mar 2018 - 30 units                              etc.   
      .
      .
      .
      Dec 2018 - 40 units

       

      Unfortunately I can't post my workbook due to company policy.

       

      With kind regards,

       

      ZZ