Percent of Total

Contents[Hide]

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.

The Percent of Total Group function can be optionally used to return the percentage of each value out of the total sum of its group, where the values are grouped by the specified hierarchies.

1. Syntax

Percent of total:

PERCENTTOTAL(d0, Alignments..)

Percent of total group:

PERCENTTOTALGROUP(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. 

Formula - Percent of Total input data
Formula - Percent of Total input data

3. Parameters

The Percent of Total function requires the following parameters:

  • Alignments... (One or More, Optional) – Hierarchy placeholders to be used as the alignment axis.

3.1. Add the formula

Add the formula
Add the formula

4. Output

The Percent of Total and the Percent of Total Group functions generate a result set in decimal format, where each value represents a portion of the total (1). 

4.1. Change the presentation (optional)

For example, a common practice is to use the calculated values for percentage labels:

  1. Change the formatting on the measure.
    Format the measure
    Format the measure
  2. Hide the measure.
    Hide the measure
    Hide the measure
  3. Add the measure values to the data point labels.
    Add to the data point labels
    Add to the data point labels

Show the Percent of Total as labels
Show the Percent of Total as labels

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:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri