Cumulative Total

Contents[Hide]

The Cumulative Total function computes the cumulative total (or running sum) of a set of input values.

Cumulative Total
Cumulative Total

The Cumulative Total Group function can be optionally used to compute the cumulative total (or running sum) of a set of input values grouped by a specific hierarchy.

1. Syntax

Cumulative Total:

CMLTOTAL(d0,Alignments...)

Cumulative Total Group:

CMLTOTALGROUP(d0,Alignments...)

2. Input

The Cumulative Total functions require the following input:

  • d0 - The set of data values for which the Cumulative Total is calculated.

3. Parameters

The Cumulative Total functions accept the following parameters:

  • Alignments... (One or More, Optional) – Hierarchy placeholders to be used as the alignment axis.
    • For CMLTOTAL, specifying a hierarchy calculates cumulative totals for the corresponding input values separately each time they occur: e.g., CMLTOTAL($Measure$, $Year$) can calculate separate running totals of yearly values within each Country group.
    • For CMLTOTALGROUP, specify the hierarchies by which to group the input values and calculate cumulative totals within each group: e.g., CMLTOTALGROUP($Measure$, $Country$) will calculate a running total of the values within each country.

4. Output

The Cumulative Total function generates the following output:

  • Cumulative Total - The Cumulative Total result set.

The Cumulative Total Group function generates the following output:

  • Cumulative Total Group - The Cumulative Total Group result set.

5. See also

Dundas Data Visualization, Inc.
400-15 Gervais Drive
Toronto, ON, Canada
M3C 1Y8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri