初学透视表问题求助各位高手

kyle_mao · 发表于 2010-10-5 18:03

小弟这几天正在学透视表,如下问题
我想用透视表对附件sheet1进行汇总,即汇总出每个人每种产品的总金额,
sheet2是我用公式做出来的,假如用透视表该怎么做呢,试了好几次好像不可以,请大侠指点一二,谢谢!

suwenkai · 发表于 2010-10-5 18:25

表格不适合做数据透视表，如果一定要做的话，只能用SQL+数据透视表这种方式做。

suwenkai · 发表于 2010-10-5 18:37

select F4 AS 姓名,F10 as 数量,F11 as 金额,"产品1(总销售)" as 品名 from [sheet1$a2:k] where 产品1 is not null union all
select F4,F10,F11,"产品2(总销售)" from [sheet1$a2:k] where 产品2 is not null union all
select F4,F10,F11,"产品3(总销售)" from [sheet1$a2:k] where 产品3 is not null union all
select F4,F10,F11,"产品4(总销售)" from [sheet1$a2:k] where 产品4 is not null

mn860429 · 发表于 2010-10-5 18:41

select f4,f11,'产品1' from [sheet1$a2:k] where 产品1 union all
select f4,f11,'产品2' from [sheet1$a2:k] where 产品2 union all
select f4,f11,'产品3' from [sheet1$a2:k] where 产品3 union all
select f4,f11,'产品4' from [sheet1$a2:k] where 产品4
练练手

		自动登录	找回密码
密码			免费注册

[求助] 初学透视表问题求助各位高手