Insert Calculated Measure Items

1.   Right-click anywhere in the view or right-click the Measure Items folder in view explorer, and select Insert Calculated Measure Item.

2.   In the Expression window, set up the expression by:

• Clicking or dragging and dropping objects from the View Items and Functions section to the Expression section.

• Or, by manually entering text in the Expression section.

3.   Use the Validate button as needed to check for any errors as you set up the expression.

4.   Click OK.

5.   {Optional} Customize properties for the measure item:

• Edit the caption expression

• Edit basic properties (name, format string, totals, etc.)

• Make a measure item "Distinct"

Note: See examples in Creating Expressions for Calculated Measure Items. See also When to Use the “Sum” Total Setting for Measure Items.