• YOu can't do the sum in a pivot by itself. However, you could do pre-aggregation in a CTE or subquery then pivot the results. That might just do it for you