Skip to Content
0
Feb 21, 2009 at 12:52 AM

Subtotal by Series

29 Views

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