回答：参数什么的呢，有权限过滤什么的吗？

回答：数据集预览没有报错的话，字段取 别名了吗？

回答：看下这边是不是没有预定义样式，没有的话可以选择重装或者参考链接所说 https://bbs.fanruan.com/wenda/question/52663.html

回答：截图1还原你的问题，截图2是解决方案 按照我标注的那样写参数

回答：大致的表样 以及 A、B表之间如何关联可以提供下吗，不然有点没有头绪啊

回答：select  字段1，字段2 from 表 where  字段2 like '%2%'或者select  字段1，字段2 from 表 where instr(字段2，'2',1,1)>0

回答：select        to_char(t.CREDATE,'mm') as CREDATE,                          t.ENTRYID,    case when nvl(t1.TOTAL,0)=0 then 0 else nvl(sum(t.TOTAL),0)/nvl(t1.TOTAL,0) end as "同比TOTAL",--同比    case when nvl(t1.SETTLEQTY,0)=0 then 0 else nvl(sum(t.SETTLEQTY),0)/nvl(t1.SETTLEQTY,0) end as "同比SETTLEQTY",--同比        nvl(t1.TOTAL,0) as "同期TOTAL",--同期        nvl(t1.SETTLEQTY,0) as "同期SETTLEQTY",--同期        nvl(t2.TOTAL ,0)as "去年TOTAL",--去年        nvl(t2.SETTLEQTY,0) as "去年SETTLEQTY",--去年        to_char(t.CREDATE,'yyyy-mm') as YEARN,        to_char(t.CREDATE,'yyyy') as YEAR,        nvl(sum(t.TOTAL),0) as TOTAL,--当月        nvl(sum(t.SETTLEQTY),0) as SETTLEQTY--当月from BMS_SA_DTLQRY_V tleft join (select  ENTRYID,        to_char(CREDATE,'yyyymm') as year_mon,        sum(TOTAL) as TOTAL,        sum(SETTLEQTY) as SETTLEQTYfrom BMS_SA_DTLQRY_Vgroup by to_char(CREDATE,'yyyymm'),ENTRYID)t1        on to_char(add_months(t.CREDATE,-12),'yyyymm')=t1.year_mon and t.ENTRYID=t1.ENTRYIDleft join (        select ENTRYID,                to_char(CREDATE,'yyyy') as yearn,                sum(TOTAL) as TOTAL,                sum(SETTLEQTY) as SETTLEQTYfrom BMS_SA_DTLQRY_Vgroup by to_char(CREDATE,'yyyy'),ENTRYID)t2     on  to_char(add_months(t.CREDATE,-12),'yyyy')=t2.yearn and t.ENTRYID=t2.ENTRYIDgroup by to_char(CREDATE,'mm'),        to_char(t.CREDATE,'yyyy-mm'),        to_char(CREDATE,'yyyy'),        t1.TOTAL,                                t.ENTRYID,        t1.SETTLEQTY,        t2.TOTAL,        t2.SETTLEQTY

回答：数据集的SQL 跟你数据库查询的SQL一样吗，看截图是字段2 有差异啊

回答：大致SQL如下select  sum(case when substr(日期字段,1,6)<to_char(sysdate,'yyyymm') then 统计字段 else 0 end) as 字段1,--1-5月总和 sum(case when substr(日期字段,1,6)=to_char(sysdate,'yyyymm') then 统计字段 else 0 end) as 字段2,--6月总和 sum(case when substr(日期字段,1,6)>to_char(sysdate,'yyyymm') then 统计字段 else 0 end) as 字段3,--7-12月总和 sum(统计字段) as 字段4--1-12月总和from 表名where substr(日期字段,1,4)=to_char(sysdate,'yyyy')

回答：看错了 抱歉