you see my image and sql file why not sum and group into one line ?
Code:
SELECT DISTINCT 
                      TOP (100) PERCENT dbo.TABHDBHCT.MACUAHANG, dbo.TABHDBHCT.MAHDBH, dbo.TABHDBH.MABAN, dbo.TABHDBH.SOPHIEU, 
                      SUM(dbo.TABHDBHCT.SOLUONG * dbo.TABHDBHCT.GIABAN) AS TIENHANG, 
                      SUM(dbo.TABHDBHCT.SOLUONG * CASE WHEN [MANHOM] = 14 THEN TABHDBHCT.GIABAN ELSE 0 END) AS TTGIO, dbo.TABHDBH.GIAMPGIO, 
                      SUM(dbo.TABHDBH.GIAMTGIO) AS TGIAMTGIO, SUM(dbo.TABHDBHCT.SOLUONG * dbo.TABHDBHCT.GIAMTIENCK) AS TGIAMTIENCK, 
                      SUM(dbo.TABHDBHCT.SOLUONG * CASE WHEN [MANHOM] <> 14 THEN (TABHDBHCT.GIABAN - TABHDBHCT.GIAMTIENCK) ELSE 0 END) AS TTDU, 
                      dbo.TABHDBH.GIAMPDU, SUM(dbo.TABHDBH.GIAMTDU) AS TGIAMTDU, 
                      SUM(dbo.TABHDBHCT.SOLUONG * (dbo.TABHDBHCT.GIABAN - dbo.TABHDBHCT.GIAMTIENCK)) AS TONGTIEN
FROM         dbo.TABHDBHCT INNER JOIN
                      dbo.TABHDBH ON dbo.TABHDBHCT.MAHDBH = dbo.TABHDBH.IDHDBH
WHERE     (dbo.TABHDBHCT.MAHDBH = 62) AND (dbo.TABHDBHCT.MACUAHANG = 1) AND (dbo.TABHDBHCT.DEL = 0) AND (dbo.TABHDBH.DEL = 0)
GROUP BY dbo.TABHDBHCT.MACUAHANG, dbo.TABHDBHCT.MAHDBH, dbo.TABHDBH.MABAN, dbo.TABHDBH.SOPHIEU, dbo.TABHDBHCT.SOLUONG, 
                      dbo.TABHDBHCT.GIABAN, dbo.TABHDBHCT.GIAMTIENCK, dbo.TABHDBHCT.MANHOM, dbo.TABHDBH.GIAMPGIO, dbo.TABHDBH.GIAMTGIO, dbo.TABHDBH.GIAMPDU, 
                      dbo.TABHDBH.GIAMTDU
ORDER BY dbo.TABHDBHCT.MAHDBH
Name:  sumtotal.jpg
Views: 2231
Size:  22.6 KB