This content has been marked as final. Show 3 replies
I need to make a summary table that calcalate the 3 months average with mulitple diminsions in straight table is as below:
|Date||Region||A||3 Month Avg(A)||(Explaination)|
|2011/11||A||217.9||72.6||(0 + 0 + 217.9)/3|
|2011/12||A||275.6||164.5||(0 +217.9 + 275.6)/3|
|2012/01||A||457.8||317.1||(217.9 + 275.6 + 457.8)/3|
|2012/05||A||0||278.3||( 477.1 + 357.7 + 0)/3|
|2012/06||A||0||119.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.