1 2 Previous Next 27 Replies Latest reply on Mar 26, 2018 5:45 AM by daniel.andell

    Running total acc per month

    daniel.andell

      I would like to make a running 12-month chart from the data I have in my example. But I would like to do this a new way. I would like it to show the last active month last. Since it is February now I would like to have February in the back and have 12 months lined up from that.
      Instead of showing the value for each month I would like each month to show the total of the last 12 months until that specific month.

      So for example we have the following data

       

       

      Now I would like to show the following in the running chart. That means February takes the sales accumulated from the last 12 months and the same goes for all months.

       

        1 2 Previous Next