Array
(
)

Quantidade acumulada, valor acumulado, mensal how to

Artarian
   - 22 abr 2008

#Código

   1.
      SELECT
   2.
      case when t6.itemname IS NULL then ´Total de Produtos´
   3.
      else t6.itemname
   4.
      end AS Produto,
   5.
      sum(T0.Quantity) AS ´Quantidade´,sum(T0.LineTotal) AS ´Valor Total´,´Month Quantity´ AS ´Quantidade Acumulada´, ´Month Total´ AS ´Acumulado do Mes´  FROM  [dbo].[INV1] T0  INNER  JOIN [dbo].[OINV] T1  ON  T1.DocEntry = T0.DocEntry INNER  JOIN [dbo].[INV12] T4  ON  T4.DocEntry = T1.DocEntry  
   6.
      LEFT JOIN OHEM T5 ON T5.Empid = T1.Ownercode
   7.
      INNER JOIN OITM T6 ON T6.Itemname = T0.Dscription AND T1.DocDate BETWEEN ´2008-04-15´ AND ´2008-04-15´ AND T1.DocEntry NOT IN ( SELECT dnf1.BaseRef FROM OINV dnf INNER JOIN INV1 dnf1 ON dnf.DocEntry = dnf1.DocEntry
   8.
                                                  WHERE dnf.SeqCode = 1 AND dnf1.BaseType = 13) AND t0.cfopcode <> 6152 AND T1.DocEntry NOT IN ( SELECT dnf1.BaseRef FROM ORIN dnf INNER JOIN RIN1 dnf1 ON dnf.DocEntry = dnf1.DocEntry
   9.
                                                  WHERE dnf.SeqCode = 1 AND dnf1.BaseType = 13)
  10.
      GROUP BY t6.itemname


Como eu faco uma quantidade e valor vendido mensalmente de cada produto nessa query como o campo mostra?