• try this

    ;with data_cte
    as    (
            SELECT

                    A.Custom2 as State,
                    Case
                        when A.Defecttype = 'BUG' then 1 else 0
                    end as BCNT,
                    Case
                        when A.Defecttype = 'ENHANCEMENT' then 1 else 0
                    end as ECNT
            FROM    IM_V_Defects A
            WHERE        A.ProjectName = ' Billing'
                    and A.Status <> 'Closed'
                    and A.Defecttype IN ('BUG','ENHANCEMENT')
            GROUP    BY A.Custom
        )    

    Select    
            State,
            SUM(BCNT) as BCNT,
            SUM(BCNT) as ECNT

    from    data_cte    a    
    Group by
            State