10 Replies Latest reply: Nov 5, 2012 1:29 AM by Jörg Hildebrandt RSS

    set analysis cumulated sum for several months

    Jörg Hildebrandt

      Dear all

       

      I hope that someone can help me.

       

      I have a table with values over a calendar year.

       

      I want to build up a set analysis, where I can define a date, e.g. 31.07.2012

       

      The analysis should give me the following results:

       

      Cumulated sum of values 01/2012

      Cumulated sum of values 01/2012+02/2012

      Cumulated sum of values 01/2012+02/2012+03/2012

      Cumulated sum of values 01/2012+02/2012+03/2012+04/2012

      Cumulated sum of values 01/2012+02/2012+03/2012+04/2012+05/2012

      Cumulated sum of values 01/2012+02/2012+03/2012+04/2012+05/2012+06/2012

      Cumulated sum of values 01/2012+02/2012+03/2012+04/2012+05/2012+06/2012+07/2012

       

      Tanks a lot for your help.

       

      Best regards

      Joerg