Calculation Wizard: Cumulative total calculation

The Calculation Type page 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.

Formula Description

This formula is used to return the cumulative total of measure data over time periods within each level of a specified dimension.

An example of this calculation is:

Cumulative Sales for 2001= Sales Q1 + Sales Q2 + Sales Q3 + Sales Q4