select Grp, PostPd,
    sum(case when month(SvcDt)=1 then Charge_Amt else 0 end) as Jan,
    sum(case when month(SvcDt)=2 then Charge_Amt else 0 end) as Feb,
    sum(case when month(SvcDt)=3 then Charge_Amt else 0 end) as Mar,
    sum(case when month(SvcDt)=4 then Charge_Amt else 0 end) as Apr,
    sum(case when month(SvcDt)=5 then Charge_Amt else 0 end) as Mar,
    sum(case when month(SvcDt)=6 then Charge_Amt else 0 end) as Jun,
    sum(case when month(SvcDt)=7 then Charge_Amt else 0 end) as Jul,
    sum(case when month(SvcDt)=8 then Charge_Amt else 0 end) as Aug,
    sum(case when month(SvcDt)=9 then Charge_Amt else 0 end) as Sep,
    sum(case when month(SvcDt)=10 then Charge_Amt else 0 end) as Oct,
    sum(case when month(SvcDt)=11 then Charge_Amt else 0 end) as Nov,
    sum(case when month(SvcDt)=12 then Charge_Amt else 0 end) as Dec
from formatIDX_Income
where year(SvcDt)='2011'
and PayCode='99'
group by Grp, PostPd
order by Grp, PostPd