主题：[求助]筛选条件二选一

Se/ect 类型,名称,年份,季度,iif(实际=-1,'预估','实际') as 性质, iif(实际=-1,预估,实际) as 金额 from (se/ect 类型,名称,年份,季度,Sum(iif(性质 = '实际',金额,-1)) As 实际,Sum(iif(性质 = '预估',金额,-1)) As 预估 from {表A} Group by 类型,名称,年份,季度) as A

如果是SqlServer数据库，把iif改为case when：http://www.foxtable.com/webhelp/topics/1827.htm

Se/ect 类型,名称,年份,季度,(case when 实际=-1 then '预估' else '实际' end) as 性质, (case when 实际=-1 then 预估 else 实际 end) as 金额 from (se/ect 类型,名称,年份,季度,Sum(case when 性质 = '实际' then 金额 else -1 end) As 实际,Sum(case when 性质 = '预估' then 金额 else -1 end) As 预估 from 表A Group by 类型,名称,年份,季度) as A

嗯，－1改成0，好象可以了

Dim sql As String = "Se/ect 编号,部门,类型,名称,年份,季度,(case when 实际=0 then '预估' else '实际' end) as 性质, (case when 实际=0 then 预估 else 实际 end) as 成本金额 from (se/ect 编号,部门,类型,名称,年份,季度,Sum(case when 性质 = '实际' then 成本金额 else 0 end) As 实际,Sum(case when 性质 = '预估' then 成本金额 else 0 end) As 预估,Sum(case when 性质 = '实际' then 目标成本 else 0 end) As 实际,Sum(case when 性质 = '预估' then 目标成本 else 0 end) As 预估 from 汇总三 Group by 编号,部门,类型,名称,年份,季度) as A" 

以上只有成本金额时没问题，加了目标成本即标颜色部分后，就生成不了，要怎么改下，SQL不太懂

Dim sql As String = "Se/ect 编号,部门,类型,名称,年份,季度,(case when 实际=0 then '预估' else '实际' end) as 性质, (case when 实际=0 then 预估 else 实际 end) as 成本金额 from (se/ect 编号,部门,类型,名称,年份,季度,Sum(case when 性质 = '实际' then 成本金额 else 0 end) As 实际,Sum(case when 性质 = '预估' then 成本金额 else 0 end) As 预估,Sum(case when 性质 = '实际' then 目标成本 else 0 end) As 目标实际,Sum(case when 性质 = '预估' then 目标成本 else 0 end) As 目标预估 from 汇总三 Group by 编号,部门,类型,名称,年份,季度) as A" 

Dim sql As String = "Se/ect 编号,部门,类型,名称,年份,季度,(case when 实际=0 then '预估' else '实际' end) as 性质,(case when 实际=0 then 预估 else 实际 end) as 成本金额 from (se/ect 编号,部门,类型,名称,年份,季度,Sum(case when 性质 = '实际' then 成本金额 else 0 end) As 实际,Sum(case when 性质 = '预估' then 成本金额 else 0 end) As 预估 from 汇总三 Group by 编号,部门,类型,名称,年份,季度) as A,(case when 实际=0 then 预估 else 实际 end) as 目标成本 from (se/ect 编号,部门,类型,名称,年份,季度,Sum(case when 性质 = '实际' then 目标成本 else 0 end) As 目标实际,Sum(case when 性质 = '预估' then 目标成本 else 0 end) As 目标预估 from 汇总三 Group by 编号,部门,类型,名称,年份,季度) as B"

导出这个表数据发上来测试