3 Replies Latest reply: Apr 16, 2017 12:34 PM by osama ahmed RSS

    How do I apply a cumulative sum to a series of data containing monthly sales?

    Oliver Clarke

      Hi

       

      If I have data organised in two columns:

       

      ([Month])

      ([sales value])   the data in this column is simply the sales volume for the month in the adjacent column

       

      And I want to display the monthly sales as a cumulative result, what is the simplest expression to use?

       

      Example:

       

      Month          Sales value

       

      Jan               £200

      Feb               £190

      March           £75

      April               £140

      May               £50

       

      Thanks!