The Calculation Type panel accepts input for the following items for a cumulative total calculation:
Accumulate -- Click the drop down arrow and select an item from the list.
Over time in -- Select the time hierarchy to be totaled in the specified dimension.
Within -- Select one of the following items to specify the area within which the cumulative total is to be performed:
Total -- Represents the sum total of the level that is associated with the current member.
Parent -- Represents the parent of the current member.
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 cumulative total of items over a specified dimension.
An example of this calculation is:
Cumulative Sales for 2001= Sales Q1 + Sales Q2 + Sales Q3 + Sales Q4