Cumulative Total Calculation

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:

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.

Formula Description

Description

This formula is used to calculate the cumulative total of items over a specified dimension.

Example

An example of this calculation is:

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