[问题求助]分类汇总合计值结果不对

如图：做了一列销售量大于2000000的判断，符合的为1，不符合为0.合计值相加的时候，法系和韩系的合计值出现了两种情况。

可以看一下这个的计算字段，步骤吗?还有版本信息https://wiki.smartbi.com.cn/pages/viewpage.action?pageId=76679842。

  
SQL监控语句：select count(*) from (select T48.`F43` as F51,T48.`F45` as F52,T48.`F47` as F53,T48.`F63` as F64 from (select T49.`F42` as `F43`,T49.`F44` as `F45`,SUM(T49.`F46`) as `F47`,if(sum(T49.`F46`)>2000000,count(distinct(T49.`F44`)),0) as `F63` from (select T50.`column10` as `F46`,T50.`column2` as `F42`,T50.`column3` as `F44` from `car_selling_fact` T50) T49 group by T49.`F42`,T49.`F44`) T48 ) tcounttable
版本信息：
Build: 2021-12-24 18:55:16
Version:9.7.69954.21525
TAG:Branch_SmartbiV97_20210324

你可以先建立一个原生SQL数据集 把需要的数据查出来
再去创建透视分析，合计即可~