Using a mathematical calculation in a cross tab
Figure 4-10 shows a computed measure that displays the Percent of Column Total value for each revenue value. For example, in the Planes column, each Percent of Column Total value displays the percentage of the corresponding Revenue value divided by the revenue total for Planes, $438, 256. The sum of Percent of Column Total values for each product-line column is 100%.
Figure 4-10  
How to create a computed measure using the % OF function
The % OF function supports displaying percent-of calculations in the cross tab, such as comparing a revenue value in each cell to the grand total sum of all revenue cells in the cross tab.
1  
2  
*
Percent of Revenue
*
*
*
*
Choose OK.
Figure 4-11  
Figure 4-12 shows the cross tab, displaying the Percent of Revenue column in which each percent value is a product line revenue value compared to the grand total revenue value for the cross tab, $525,153. The sum of all values in all Percent of Revenue columns is 100%.
Figure 4-12  
Displaying Percent of Revenue values for each product line revenue value compared to the cross-tab Grand Total

Additional Links:

Copyright Actuate Corporation 2012