PercentOfTotal
Returns the percent of total for an aggregate formula.
Usage
PercentOfTotal(aggregate, [mode], [parameters])
Note: This function is shorthand for: aggregate / Subtotal(aggregate, mode, parameters).
Parameters
Term | Description |
aggregate |
An aggregate formula Examples: Count(), Sum([Sales Amount]) |
mode (optional) |
The mode to use when calculating the aggregate formula. Mode determines which dimension(s) to use when performing the calculation. Mode options vary between element types: General purpose modes
Visualization modes
Pivot table modes
Table modes
|
parameters (optional) |
An additional parameter specific to the mode. |
Examples
Example #1
PercentOfTotal(Sum([Quantity] * [Price]), "row")
- The numerator of the percentage is the aggregate formula calculated along rows and columns.
- The denominator of the percentage is the aggregate formula calculated along the rows.
- The pivot table subtotals calculate the percent of total at the expected granularity.
Example #2
PercentOfTotal(Sum([Quantity] * [Price]), "x_axis")
- The numerator of the percentage is the aggregate formula calculated along the x-axis and color.
- The denominator of the percentage is the aggregate formula calculated along the x-axis.
- The calculation is shown in the tooltip, but is usable anywhere an aggregate formula is allowed.