Part of the problem you were running into was your choice of using PIVOT instead of the more flexible CROSS TAB, which Luis used. 

• PIVOT is limited to aggregating a single attribute, but you want to aggregate TWO attributes (CallCount and Duration).
• PIVOT can only reference one expression for the column definitions, but you needed to reference two (CallType and Duration).