SAP Design Studio: Calculated Measures in Charts/Crosstab

By admin Last updated Feb 15, 2022

Question: How to create calculated Measure in SAP Design Studio for Chart/Crosstab Binding?

Software version: SAP Business Object 4.2, SAP Design Studio 1.6 SP 4

Backend used: S/4 Hana CDS Views, BEx Queries

Dear Team,

This post is to share information on usage of dynamic calculated measure in SAP Design Studio for chart/crosstab binding- SAP Design Studio: Calculated Measures in Charts/Crosstab

Developers can perform below operations on individual measure to achieve new Calculated Measure: (Few more listed in actual SAP Design Studio windows)

Moving Minimum Value
Moving Maximum Value
Accumulative Sum
Moving Average
Rank Number
Percentage Contribution

Developers can perform below operations on multiple (Two or more measures) measures to achieve new Calculated Measure:

Add measures
Subtract measures
Multiply measures
Divide measures
Percentage Difference
Percentage Share

Steps to create new calculated measure in Data Source:

Create a SAP Design Studio Dashboard.
Add desired Data Source.
Right Click on Data Source and Click on Edit Initial View
Drag base measures in Columns.
To achieve new calculated measure based on individual measure- right click on any measure and navigate to Add Dynamic Calculation
Select desired calculation type and Enter a name for calculation and click on OK
This will add a new calculated measure.
To achieve new calculated measure based on multiple (Two or more measures) measures- click on first measure and press control (ctrl Button on Keyboard) and select second measure.
Follow step 8 to select multiple measures.
Now right click on selection and navigate to Add Calculation
Select desired calculation type and Enter a name for calculation and click on OK
This will add a new calculated measure.
Now developer can access these measures in charts or crosstab for binding.
Sample Screenshot for reference (Crosstab & Info Chart)-