Código SQL [-]SELECT ID ,PRODUCTO ,SUM(CANTIDAD * IMPORTE) AS TOTALIMPORTE ,DATEPART(wk, FECHA) AS SEMANA FROM Ventas GROUP BY ID, PRODUCTO, DATEPART(wk, FECHA) ORDER BY 4, PRODUCTO
SELECT ID ,PRODUCTO ,SUM(CANTIDAD * IMPORTE) AS TOTALIMPORTE ,DATEPART(wk, FECHA) AS SEMANA FROM Ventas GROUP BY ID, PRODUCTO, DATEPART(wk, FECHA) ORDER BY 4, PRODUCTO