The Calculation Type panel accepts input for the following items for a moving average calculation:
Measure -- Select the measure for which you want to calculate a moving average.
Over -- If there is more than one time dimension, then a box appears to allow the selection of the proper time dimension. Otherwise the default time dimension is used.
In -- Select the hierarchy for the specified dimension.
Include previous box -- Enter the number of periods to be used for the calculation
Number Format -- Select one of the default number formats to use for this calculation or choose Options to specify another format.
Options -- Displays the Number Format dialog, in which you can specify a format for the calculation.
This formula is used to calculate the average value for a rolling number of time periods.
An example of this calculation is:
Moving average sales for the last 3 months = (Jan Sales + Feb Sales + March Sales)/3