% 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.
© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy