Using Percentages of Total

You can derive the percentage of the total for a measure as a new aggregated measure. The aggregated measure does not contain data values in itself, but when it is used in a visualization, it displays the percentage of the total value for the measure on which it is based.

For example, you might derive the percentage of the total for a measure that contains revenue values. If you create a bar chart of the aggregated measure and a category that contains product lines, then the bar chart shows the percentage of total revenue for each product line.

To derive the percentage of the total for a measure, right-click on a measure in the Data pane, and then select Derive Percent of Total. The derived measure appears automatically in the Data pane. The name of the aggregated measure is the same as the measure on which it is based, with the suffix “(Percent of Total).”

Aggregated measures can be used in the following visualization types: