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

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

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 预估 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"

汇总四生成不了

就是性质里面有预估和实际两种情况，同一月份如果即有预估又有实际，就取实际的数据，如果没有实际就取预估的数据，直接弄不了。看1楼、2楼