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 xaxis and color.
 The denominator of the percentage is the aggregate formula calculated along the xaxis.
 The calculation is shown in the tooltip, but is usable anywhere an aggregate formula is allowed.