Count y Sum en una misma consulta SQL

[enlinea777]

asi:

Código MySQL:

SELECT cod_suc, [001] AS INDIRECTO ,[002] AS DIRECTO ,[003] AS CORPORATIVO, ([001] + [002] + [003]) AS TOTAL
FROM
(SELECT cod_suc ,tip_recep, cat_dis , cat_dis AS "TIPO_VENTA" , semana
FROM temporalGerente) AS temporal
PIVOT
(
COUNT(semana)
FOR TIPO_VENTA IN ([001],[002],[003])
) AS pivotTable WHERE tip_recep IN ('PS','SN','WB')
ORDER BY cod_suc ASC