[olbeup]

Hola Theluar,

Mira haber esta, no lo he probado:

Código SQL [-]
SELECT
    FECHA
    ,SUM(TOTAL) AS TOTALVENTA
    ,SUM(
      CASE
        WHEN IVA > 0 THEN TOTAL
        ELSE 0
      END
     ) AS TOTALCIVA
    ,SUM(IVA) AS TOTALIVA
  FROM Ventas
  GROUP BY FECHA

Un saludo.