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.

1. Syntax

PERCENTTOTAL(d0, Alignments..)

2. Input

The Percent of Total function requires the following input series:

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 function generates a result set in a 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: 7am-6pm, ET, Mon-Fri