Totals (Sum)


The Sum function calculates the sum total for a set of input values.

1. Syntax


2. Input

The Sum function requires the following input:

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

Example input data
Example input data

3. Parameters

The Sum function accepts the following parameters:

  • Alignments... (One or More, Optional) – Hierarchy placeholders to be used as the alignment axis. Input values are grouped by the specified hierarchy values, and the sum calculated for each group: e.g., SUM($Quantity$, $Country$) calculates the total for each country.

4. Output

The Sum function generates the following output:

  • Total - A single value representing the sum total of the input values (or for each group when using alignment parameters).

Result displayed as a 2nd series (lighter blue)
Result displayed as a 2nd series (lighter blue)

To display the output in a separate visualization such as a data label, you can use a formula visualization.

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