3 Replies Latest reply: Jul 3, 2012 4:43 AM by Herman Li RSS

    n Month average with multiple dimensions in straight table

      Hi all,

       

      I need to make a summary table that calcalate the 3 months average with mulitple diminsions in straight table is as below:

       

       

      DateRegionA3 Month Avg(A)(Explaination)
      2011/11A217.972.6(0 + 0 + 217.9)/3
      2011/12A275.6164.5(0 +217.9 + 275.6)/3
      2012/01A457.8317.1(217.9 + 275.6 + 457.8)/3
      2012/02A456.1396.5
      2012/03A477.1463.7
      2012/04A357.7430.3
      2012/05A0278.3( 477.1 + 357.7 + 0)/3
      2012/06A0119.2( 357.7 + 0 + 0)/3

       

      I got the Date, Region and A and I need to calculate the average of A (3 Month Avg(A)). I have make a explaination column in the above example to make it clear what i want to do.

       

      As it is multiple dimensions, I cannot use rangesum & above and i tried to use aggr but no joy. Also, by input a int, it can calculate any month avg, so..I cannot hard code the formula just calculate 3 months..

       

      Please kindly help.

       

      Best Regards,

      Nick