SELECT meetingnumber, SUM( CASE WHEN ChargeType1 = '1' AND RptCode = 'PACU' THEN y_Sent_To_Charge ELSE 0 END) AS PACU_ChargeType1, SUM( CASE WHEN ChargeType1 = '2' AND RptCode = 'PACU' THEN y_Sent_To_Charge ELSE 0 END) AS PACU_ChargeType2, SUM( CASE WHEN ChargeType1 = '1' AND RptCode = 'OR' THEN y_Sent_To_Charge ELSE 0 END) AS OR_ChargeType1, SUM( CASE WHEN ChargeType1 = '2' AND RptCode = 'OR' THEN y_Sent_To_Charge ELSE 0 END) AS OR_ChargeType2 FROM ( < your query > ) dt1 GROUP BY meetingnumberOr you can combine it with the original query.