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.
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.
Percent of total:
Percent of total group:
The Percent of Total function requires the following input series:
- d0 - The set of data values for which the formula is calculated.
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
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:
- Change the formatting on the measure.
- Hide the measure.
- Add the measure values to the data point labels.