Working with Calculated Measures

Calculated measures are derived from other measures and created by using formulas.

To create a calculated measure:

1. Perform one of the following actions:

   • To create a calculated measure for data views that contain columns within the Compound Layout, click the New Calculated Measure button on the "Analysis editor: Results tab."

   • To create a calculated measure for a specific data view within the Compound Layout, edit the specific data view, and then click the New Calculated Measure button on the "Results tab: Data View editor."

     
     

     Note: You cannot add calculated measures to direct database queries or combined requests.

     
     

2. Complete the "New Calculated Measure dialog." See "Editing the Formula for a Column" for information about column formulas.

3. Click the OK button.

To edit a calculated measure:

You can edit a calculated measure from the "Analysis editor: Criteria tab."

1. In the Criteria tab, click the Options button to the right of the column name for the calculated measure.

2. Modify the columns as needed.

   • Specify the sort order for columns. (You cannot specify the sort order for hierarchy levels.) For more information, see "Sorting Data in Views."

   • Edit formulas for attribute columns and measure columns, including customizing headings, and specifying the aggregation rule. (You cannot customize headings, specify the aggregation rule, or edit the formulas for hierarchical columns or for hierarchy levels.) For more information, see "Editing the Formula for a Column."

   • Edit column properties to control the formatting and interaction of columns and hierarchy levels. For more information on applying formatting, see "Applying Formatting to a Column."