Otra Forma de como Hacerlo
Código sql:
Ver originalSELECT Factura,Movil,ISNULL([BAM],0) AS BAM,ISNULL([MMS],0) AS MMS,ISNULL([RPV],0) AS RPV,
ISNULL([SME],0) AS SME,ISNULL([SMR],0) AS SMR,ISNULL([TEL],0) AS TEL,
ISNULL([TLL],0) AS TLL,
([BAM] + [MMS] + [RPV] + [SME] + [SMR] + [TEL] + [TLL]) AS TOTAL
FROM
(
SELECT Factura,Movil,Servicio FROM Trafico
) V PIVOT (SUM(VALOR + AGREGADO) FOR SERVICIO IN([BAM],[MMS],[RPV],[SME],[SMR],[TEL],[TLL])) AS PT
ORDER BY FACTURA,MOVIL