
This is the Table (expected output)
ProductName Year Q1 Q2 Q3 Q4 Total
BXRC-25e4000-F-04 2014 100 200 300 400 1000
2015 100 100
BXRC-25e4000-F-23 2014 200 200 400
2015 300 300
Subtotal ------------ 700 200 300 600 1800
But i get the o/p as:
ProductName Year Q1 Q2 Q3 Q4 Total
BXRC-25e4000-F-04 2014 500 200 300 400 1400
BXRC-25e4000-F-23 2014 200 200 400
Subtotal ------------ 900 200 400 800 1800