Adding an advanced Calculated Measure

  1. In Calculated Measure, click Add (Adv).
    The Add advanced Calculated Measure dialog box is displayed.
  2. Specify this information:
    Column Measure Name
    Specify the name of the new calculated measure.
    Description
    Optionally, specify a description of the new calculated measure.
  3. In Measures, select from the drop-down list of measure and click Attached .
    The selected measure is displayed in the Formula field.
  4. Select from the four basic arithmetical operations and mathematical function. You can also introduce constant values by specifying them in the Constant field.
    You must add new elements to the formula one by one and selecting the element and clicking Attached . The formula is displayed in the Formula text field.
  5. Click OK once your calculated measure is complete.