3 Replies Latest reply: Feb 28, 2012 6:38 AM by Celambarasan Adhimulam RSS

    Simple runnign sum question

    Martin Goebbels

      I have a table with list of sales data (store, month_of_sale, value)

       

      i want to put on a graph the sales values and on year acumulated sales values, month by month.

       

      if i would build a table with this data to show it on a bar chart , each row in this table would be like this:

       

      ( store, month_of_sale, value, sum(value where month_of_sale between first_month_of_the_year and current month_of_sales) )

       

      Example:

       

      ( Store_1, jan/2011,1000, 1000 )

       

      ( Store_1, feb/2011, 2000, 3000 )

       

      ( Store_1,mar/2011,3000, 6000 )

       

       

      How would i build the expression for this 3rd expression? I saw a lot of examples with rangesum, below, before, but it's quite unclear for me.