maybe my subject is wrong. i already do a concatenation in this statement
'RM' + (CAST(CAST(SUM(SLDXX_InvoiceDetail.UnitPrice * SLDXX_InvoiceDetail.Qty) AS NUMERIC(9,2)) AS VARCHAR(10)))
below is the output from the code
ProductGroupName Quantity Amount
Media...