Skip to Content
0
Former Member
Jun 10, 2011 at 05:19 AM

Calculation

42 Views

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?

Regards

Amandeep Sharma

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