如何运用透视表技术生成表中想要的汇总格式

wwwbjwww

如题,详见附件,如何运用透视表生成附件中的汇总表格式,谢谢!

啸傲东轩

觉得你的表格设置不合适。修改了下，看看是否适合。

jianbing

SQL:

select 月份,"自制半成品委托加工" as item, 自制半成品委托加工数量 as 数量, 自制半成品委托加工金额 as 金额 from [Sheet1$a1:l21] union all select 月份,"外球笼" as item, 外球笼数量 as 数量, 外球笼金额 as 金额 from [Sheet1$a1:l21] union all select 月份,"内球笼" as item, 内球笼数量 as 数量, 内球笼金额 as 金额 from [Sheet1$a1:l21] union all select 月份,"轴承" as item, 轴承数量 as 数量,轴承金额 as 金额 from [Sheet1$a1:l21] union all select 月份,"万向节" as item, 万向节数量 as 数量, 万向节金额 as 金额 from [Sheet1$a1:l21]