SUM in Query Generator

[RajuParmar]

Hi, I have the following query

SELECT T0.[CardCode] AS 'Customer Code', T0.[CardName] AS 'Name', T0.[DocDate] AS 'Entry Date', T0.[DocNum] AS 'Order Number', T1.[ItemCode], T1.[Quantity], T3.[AvgPrice] AS 'Unit Cost', T1.[Price] AS 'Unit Sale Price', T1.[LineTotal] AS 'Gross Value', (1-T3.[AvgPrice]/T1.[Price])*100 as 'R.M. Profit %', T2.[U_INDCODE] FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode INNER JOIN OITW T3 ON T2.ItemCode = T3.ItemCode

I wanted to know how can i get subtotal by Quantity, LineTotal by Customer

[Former Member]

This is not a Solution Manager query and hence the thread is closed.

kindly please use a Appropriate SDN Forum to open the thread.