1 declare @table table(
 2 company_id int ,--公司编号
 3 quarter_num char(2),--季度
 4 disti varchar(50),--分销商
 5 num int --数量
 6 )
 7 
 8 insert @table
 9 values(1,'Q1','D1',1),(1,'Q1','D1',2)
10 ,(1,'Q3','D2',1)
11 ,(1,'Q4','D1',1)
12 ,(1,'Q2','D1',1)
13 ,(2,'Q1','D1',1)
14 ,(2,'Q3','D1',3)
15 ,(2,'Q4','D1',4)
16 ,(2,'Q2','D1',2)

select 
b.company_id,b.quarter_num,b.disti,SUM(a.num) [YTQ]
from @table a join (select distinct company_id,quarter_num,disti from @table )b 
    on a.company_id=b.company_id and a.disti=b.disti and a.quarter_num<=b.quarter_num
group by b.company_id,b.quarter_num,b.disti