You can use the Add Calculation dialog to create a new data element—typically a measure—to add to your visualization. For example, you can create a new measure called Profit. This new data element might involve the Revenue and Discount Amount measures.
To add a calculation:
- Launch the Add Calculation dialog in one of two ways:
At the bottom of the Data Elements pane, click Add Calculation.
In the Data Elements pane, right-click the My Calculations folder and select Add Calculation.
- In the Expression Builder, compose an expression. See About Composing Expressions.
For example, to create the new measure called profit, compose this expression: "Sample Sales"."Base Facts"."Revenue"-"Sample Sales"."Base Facts"."Discount Amount".
- Optionally, click Validate.
- In the Display field, enter a data element name.
- Click Save.
The new data element is created and you can use it in your visualizations as you would any other data element. For example, in visualization drop targets or in filters.