8 Replies Latest reply on Feb 18, 2016 7:27 AM by Shinichiro Murakami

    Dynamic cummulative sum like excel

    nestor diaz

      Hi. I have been trying to generate a formula that accumulate values in a dynamic way like excel do.

      For example: I have a data source (first 2 colums), with a date field and values for each day. I would like to generate, in another table, an output (like 3rd and 4th colums) that accumulate, for the next 10 days, and put result the within the day where the sum begin.

      I dont know if there is any expression that can do this job or if I need to create filter or parameter.

       

      Español: Necesito ir acumulando de forma dinámica por 10 días e ir colocando esta suma en cada celda. Si el día es 5 de enero, acumular desde el 5-14 y colocar esta suma en el día 5. Para el día 6, acumular desde el 6-15, y así respectivamente. Agradezco si conocen alguna sentencia o método para lograr este resultado.

          

      Data SourceOutput
      DateValuesDateValueExplanation
      1/1/201511/1/201524sum from day 1-10
      1/2/201521/2/201524sum from day 2-11
      1/3/201531/3/201530sum from day 3-12
      1/4/201511/4/201532sum from day 4-13
      1/5/201521/5/201532sum from day 5-14
      1/6/201551/6/201532sum from day 6-15
      1/7/20151
      1/8/20152
      1/9/20153
      1/10/20154
      1/11/20151
      1/12/20158
      1/13/20155
      1/14/20151
      1/15/20152

       

      I hope you can understand  and help me in this case.

       

      Regards,