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