Percent of Total


The Percent of Total function returns the percentage of each value in the input series out of the total sum of the values in the input series.

1. Syntax

PERCENTTOTAL(d0, Alignments..)

2. Input

The Percent of Total function requires the following input series:

  • d0 - The set of data values for which the formula is calculated.
  • Alignments (Optional) - Hierarchy placeholders to be used as the Alignment Axis. Can be one or more hierarchies, separated by a comma.

3. Parameters

The Percent of Total function has no parameters.

4. Output

The Percent of Total function generates the following output:

  • Percent of Total - The Percent of Total result set.

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

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