The Calculation Type page accepts input for the following items for a moving total calculation:
Measure
Select the measure for which you want to calculate a moving total.
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
Enter the number of periods to be used for the calculation.
This formula is used to return the total value for a measure over a rolling number of time periods.
An example of this calculation is:
Moving total sales for the last 3 months = (Jan Sales + Feb Sales + March Sales)
Copyright © 2003, 2007, Oracle. All rights reserved.