I am getting data from SQL server like below:
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?
Edited by: AmanSharma123 on Jun 10, 2011 7:20 AM
Parth Kulkarni replied
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