crosstab

[maetrox kulon]

Hello, this is about code below :-

select year(my.invoiceDate) as year, C2.company,

(select sum(case when
isGST ='GST' then (total * 0.06) + total
else total end)
from trn_Invoice I
left join trn_Invoice_sub InvSub on I.invoiceNo=InvSub.invoiceNo
join mtr_charges Charge on InvSub.chargesId=Charge.chargesId
where year(I.invoiceDate)='2014' and month(I.invoiceDate)='3') as 'MAR',

(select sum(case when
isGST ='GST' then (total * 0.06) + total
else total end)
from trn_Invoice I
left join trn_Invoice_sub InvSub on I.invoiceNo=InvSub.invoiceNo
join mtr_charges Charge on InvSub.chargesId=Charge.chargesId
where year(I.invoiceDate)='2014' and month(I.invoiceDate)='4') as 'APR'

from trn_Invoice my
join mtr_customer C2 on my.ROCNo=C2.ROCNo
where year(my.invoiceDate)='2014' and my.status = '1'
group by my.ROCNo;
=============================================code_end============

...although the result is different for that two column BUT the result give me same value at each row of company,

HOW to make it related to company in each row? Please anyone can help....