% OF TOTAL

Calculates the percentage of the cross-tab grand total for each measure in each column and row.

Category

Math

Measure

Select a measure name from the list.

Returns

For each measure in each column and row, Data Analyzer calculates the percentage of the cross-tab grand total and displays the percent value, as follows

(<measure value>/<cross-tab grand total>) * 100%

The sum of all percent-of-total values in the cross tab is 100%.

Example

In Measure, select the sales revenue measure. Data Analyzer displays a percentage value in the cell next to each sales revenue value. The percentage value equals the sales revenue value, divided by the row total, and multiplied by 100%.

Copyright Actuate Corporation 2012