2 Replies Latest reply: Nov 5, 2013 3:09 AM by Stanislav Strogiy RSS

    Sum Value from month to month period

    Kelven NG

       

       

      Sum Value “From” month “To” month by 12 period.

      I want to Sum my Value base on the month of the year and by 12 period month basis

      Example my data as below:

       

      Year    Month Value

      2010   Jan         1

      2010   Feb         2

      2010   Mar         3

      2010   Apr         4

      .

      .

      .

      .

      2011   Jan         13

      2011   Feb         14

      2011   Mar         15

      2011   Apr          16

      .

      .

      .

       

      2012   Jan         25

      2012   Feb        26

      2012   Mar        27

      2012   Apr         28

       

      When I select 2012 Apr and system able to calculate sum the value by 2012 Apr from 2012 April until 2011 May And for 2012 Mar value will be sum from 2012 Mar until 2011 April and same with following months by 12 period basis

      Sample format output:

       

      2011May         2011Jun          2011Jul           2011Aug          2011Sep          2011Oct          2011Nov         2011Dec            2012Jan          2012Feb          2012Mar          2010Apr

      138                         150                         162                              174                         186                             198                          210                            222                               234                           246                            258                          270

       

      Many Thank