How to create a computed measure using a mathematical calculation
1  
2  
In Computed Measure, complete the following tasks, as shown in Figure 4-13. These tasks differ depending on the category and calculation type you select.
*
*
*
*
*
*
Figure 4-13  
Choose OK. The Rank column displays the rank for each quarter, from highest to lowest revenue value in the cross tab, as shown in Figure 4-14.
Figure 4-14  
How to edit a computed measure
Right-click a measure. From the menu, choose Edit Computed Measure. Computed Measure appears. To modify the expression, continue as described in Using a mathematical calculation in a cross tab.
How to create a custom computed measure
Data Analyzer supports creating a custom computed measure to display in the cells of a cross tab column.
1  
2  
3  
4  
Figure 4-15 shows an expression, which calculates a 25% profit from the sales revenue value.
Figure 4-15  
5  
If the expression is valid, a message appears stating the expression is valid.
To close the message, choose OK.
6  
Figure 4-16 displays the Profit column in the cross tab, using a currency format for the profit values.
Figure 4-16  

Additional Links:

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2