Hi. From the below, how can i calculate the total of col 1 + col2 + col4 and put results in new column named 'newcol5'?
Also, calculate the following: 12 mth average based on recent calendar quarter and put results as 'total12avg'? In this case it would be the average of all rows from column 'month' 2010-04 to 2011-03. Thanks.
Month col 1 col2 2 col3 x col4 'newcol 5'
2011-05 x x x x x
.......-..... x x x x x
2010-04 x x x x x
First quarter: from the beginning of January to the end of March
Second quarter: from the beginning of April to the end of June
Third quarter: from the beginning of July to the end of September
Fourth quarter: from the beginning of October to the end of December