display ikut group

SELECT CustomerName, GROUP_CONCAT( ItemDesc ORDER BY ItemDesc ) AS ItemDesc, SUM(Quantity) AS Quantity, SUM(CCLocalLineTotal) AS Total FROM
salesreportdata
GROUP BY CustomerName