Group By

[likelike2045]

The first record,I had two records.
After I set group by,
Records sum up to one and the qty should be 2000.But here just 1000. Why?
Please help!!

 

[John Big Booty]

You need to group by the first two fields and Sum the other two fields.