Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A


I am getting data from SQL server like below:

0calmonth 0amount

01.2000 100

02.2000 200

03.2000 -200

04.2000 300


01.2001 0

02.2001 100

03.2001 150


Now in Query designer I need to create output as below:

CalMonth 01.2000 02.2000 03.2000 04.2000 ....................................01.2001 02.2001 03.2001

Sum(0amount) 100 300 100 400 0 100 250

If this was just one column, I would have created this easily with the help of customer exit variable ( When I know the last Calmonth), but in this case i need to add this for all months. How I can handle this scenario?


Amandeep Sharma

Edited by: AmanSharma123 on Jun 10, 2011 7:20 AM



My suggestion will be to do this calculation at infoprovider level.

In BEx, you have one option. Add Calmonth and Amount in the Column. Go to Key Figure properties -> Calculate Single Value as -> Cumulative along the Row.

But this is just a display property, it does not actually calculate. SO you cant use these values for further calculations. If suppose you filter out one month, value of that month will be ignored

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question