% OF COLUMN
Calculates the percentage of the column total for each measure value in each column.
Category
Math
Measure
Select a measure name from the list.
Returns
For each measure in each column, Data Analyzer calculates the percentage of the column total and displays the percentage value. The sum of percent-of-column values in each column 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 column sum, and multiplied by 100%, as follows:
(<sales revenue value>/<column sum>) * 100%
An illustration of a cross tab displaying percent-of-column total values appears in Figure 4-10.

Additional Links:

Copyright Actuate Corporation 2012