Calculate Sum of 3 Successive Periods Using Rows/Areas
A demand planner has done forecasting on monthly basis and wants to get data on a rolling quarterly basis: the sum of the forecasts for January through March, the sum of the forecasts for February through April, and so on.
For example, you could create the baseline forecast in one data view and execute this macro as a start macro in a second data view as the preface to doing further forecast calculations. One possibility would be to use these rolling quarterly figures to calculate a moving monthly average and thus arrive at a smoother forecast. Alternatively, the rolling quarterly figures could form the basis for calculating other forecast adjustments.