Cumulative Total
The Cumulative Total function computes the cumulative total (or running sum) of a set of input values.
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 function requires the following input:
- d0 - The set of data values for which the Cumulative Total is calculated.
3. Parameters
The Cumulative Total function requires the following parameter:
- Alignments... (One or More, Optional) – Hierarchy placeholders to be used as the alignment axis.
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.