在源表加一列月份,输入月份值。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/79f0f736afc37931d455aa1ce9c4b74543a911c1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
然后对源数据使用“数据透视表”
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d6ca7bcb0a46f21f94fd7366f4246b600c33ae3d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
-_-|||,没注意,你是说SQL
select
[部门],
[费用项目],
sum(case when substring([日期],5,2) = '01' then [金额] else 0 end) as [1月总],
sum(case when substring([日期],5,2) = '02' then [金额] else 0 end) as [2月总],
sum(case when substring([日期],5,2) = '03' then [金额] else 0 end) as [3月总],
sum(case when substring([日期],5,2) = '04' then [金额] else 0 end) as [4月总],
sum(case when substring([日期],5,2) = '05' then [金额] else 0 end) as [5月总],
sum(case when substring([日期],5,2) = '06' then [金额] else 0 end) as [6月总],
sum(case when substring([日期],5,2) = '07' then [金额] else 0 end) as [7月总],
sum(case when substring([日期],5,2) = '08' then [金额] else 0 end) as [8月总],
sum(case when substring([日期],5,2) = '09' then [金额] else 0 end) as [9月总],
sum(case when substring([日期],5,2) = '10' then [金额] else 0 end) as [10月总],
sum(case when substring([日期],5,2) = '11' then [金额] else 0 end) as [11月总],
sum(case when substring([日期],5,2) = '12' then [金额] else 0 end) as [12月总]
from tableA
group by [部门],[费用项目]