Hi, one question:
This is My Query:
SELECT T2.SeriesName,T0.CardName,T0.DocTotal FROM OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN NNM1 T2 ON T0.Series=T2.Series WHERE datediff(day,getdate(), T0.Createdate) = 0 group by T0.CardName,T0.DocTotal , T2.SeriesNAme
I have 2 series, i want(if possible) subtotal by serie
Example:
-
SeriesName Cardname Total
Serie1 x 5
serie1 x 5
Serie1 x 5
serie2 y 10
Serie2 y 10
serie2 y 10
Serie2 y 10
-
Subtotal Serie1: 15
Subtotal Serie2: 40
Its Posible?
Regards