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.

The figure shows the Calculations on the Analysis ribbon to add a simple calculation using two measures.

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.

The figure shows the Calculations on the Analysis ribbon to add a dynamic calculation on one measure.

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.

The figure shows the Calculations on the Analysis ribbon to add an advanced calculation.

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.

The figure show the New Restriction dialog and its result in the crosstab.

Watch the video to see how to create and use Analysis calculations.

Let's summarize:

• Simple Calculations: Combine measures via Ctrl+Click and Analysis ribbon.
• Dynamic Calculations: Single measure, adjusts dynamically; accessible from Analysis ribbon.
• Advanced Calculations: Use free-form editor for complex formulas; Similar to Excel formulas.
• Restricted Measures: Limit existing measures by dimensions for specific insights.