求助数据透视表数据修正

anthonywang9

话不多说，请见附件。求高手指点，本人初学数据透视表中。
数据透视表1.rar (12.12 KB, 下载次数: 22)

2011-5-30 23:20 上传

点击文件名下载附件

[ 本帖最后由 anthonywang9 于 2011-6-2 21:24 编辑 ]

rligong

搞不好，不知道这样会不会好一点？

魂断蓝桥

select *,关闭+流转+生效 as 合计 from (select NCR编号,NCR属性,C分类,count(*) as 关闭,0 as 流转,0 as 生效 from [sheet1$a1:d66] where NCR状态="关闭" group by NCR编号,NCR属性,C分类 union all
select NCR编号,NCR属性,C分类,0,count(*) as 流转,0 from [sheet1$a1:d66] where NCR状态="流转" group by NCR编号,NCR属性,C分类 union all
select NCR编号,NCR属性,C分类,0,0,count(*) as 生效 from [sheet1$a1:d66] where NCR状态="生效" group by NCR编号,NCR属性,C分类)

anthonywang9

原帖由 魂断蓝桥 于 2011-5-31 09:08 发表
select *,关闭+流转+生效 as 合计 from (select NCR编号,NCR属性,C分类,count(*) as 关闭,0 as 流转,0 as 生效 from [sheet1$a1:d66] where NCR状态="关闭" group by NCR编号,NCR属性,C分类 union all
select NCR编 ...

魂断蓝桥兄得方法很巧妙的实现了我的要求，但是惭愧的SQL语句一句不会啊。看来还得学习啊！
不过问题已解决，再次感谢蓝桥兄！