Creating Measure Calculations

For simple calculations, you use two or more available measures to create a new measure. For example, you can create a new measure that is the sum of two available measures. Use Ctrl+Click to select the column headers of the two measures. From the Analysis ribbon select Calculations → Add Calculation and make your choice.

For dynamic calculations, you use only one available measure for the calculation. For example, you can add a new measure that displays the rank of each division according to sales volume. If you filter out or add new divisions to your analysis, the rank numbers change dynamically. Select the measure column header. From the Analysis ribbon select Calculations → Add Dynamic Calculation and make your choice.

For advanced calculations, you can use the free-form editor to create formulas with the available measures in the workbook and with various functions. Select a measure column header. From the Analysis ribbon select Calculations → Add Advanced Calculation. Use the New Calculation dialog to define your formula.

Similar to other SAP editors, you can press Ctrl+space for guidance in defining your formula.

You can add a new measure by restricting an existing measure by a dimension. For example, if a particular month of the year is significant in your business, you can restrict a measure to that month and see a comparison between the values for that month against the values for all months.