Editing a calculated measure in the report

Pentaho Analytics

Version

9.3.x

Audience

anonymous

Part Number

MK-95PDIA004-04

If you have created a calculated measure, but have not added it to the data source, you can edit that calculated measure in the Layout panel or in the report.

Click the Down Arrow next to a calculated measure in the Layout panel, select User Defined Measure from the menu, and then select Calculated Measure Properties. Optionally, you can open this dialog box in the report by double-clicking the calculated measure, or right-clicking it to select User Defined Measure > Calculated Measure Properties.
The Properties dialog box appears for that calculated measure.

You can view and/or edit the following fields.

Note: Some of the fields only display for users who are assigned the Manage Data Sources permission.

Field	Description
Display Name	The name of the measure as it displays in the model.
Format	Choose how this measure should be formatted, such as currency, general number, or percentage. Use the drop-down arrow to select a format from a system-defined list, or type in the field to enter a custom format. The Format field only displays when the value for the field is a number or a date. If you do not specify a format, the default value of the first base measure is used as the format. See Format Field Options for more information on selecting the appropriate format for your report.
Decimal Places	(Optional) Specify the number of decimal places for the results.
Type	The type of field, measure, such as calculated measure. This field is always read-only.
MDX Formula	In the right panel, enter the formula for your calculated measure. You can write the MDX statement, or you can use the list on the left to drag measures into the right panel. You can also use the symbol buttons below to help create your statement, or just use your keyboard to write the expression.
Calculate subtotals using measure formula	(Optional) Select this check box to use this calculated measure when adding up subtotals in your report. Clear this check box to not use this formula when calculating subtotals.
Apply to data source	(Optional) Select this check box to add the calculated measure to the data model. When you click OK to save this calculated measure, your calculated measure will also be saved to the data model. Once you save the report, the measure will now be available for other users to add to their reports.

Click OK to apply your calculated measure to your report. When you save your report, your calculated measure will also be saved with your report. Click Cancel to close the dialog box without applying your changes.

If you have not saved the report yet, you can click the Undo button to remove the calculated measure, even if you selected to apply it to the data source.
You can use hidden fields to create calculated measures. When you select the Show Hidden Fields option in the View menu for the Available Fields list, measures set as 'hidden' are available for selection in the Create Calculated Measure dialog box. To view hidden measures, you need the Manage Data Source permission. See Hide and Unhide Fields for additional details.