写SQL处理,我用的是Oracle数据库,KK就是你列的数据表
select aa.*, bb.ro,bb.kpje,bb.fkje
from (select gorup as gys, value as htje
from KK
where fieldlabel = '合同金额') aa
left join (select a.gys, a.ro, sum(kpje) as kpje, sum(fkje) as fkje
from (select gorup as gys, ro, value as kpje, null as fkje
from KK
where fieldlabel = '开票金额'
union all
select gorup as gys, ro, null as kpje, value as fkje
from KK
where fieldlabel = '付款金额') a
group by a.gys, a.ro) bb
on aa.gys = bb.gys
SQL查询结果
-----------------------------------------------------------------------------------------------------
设计器
注意:合计A3的左父格是A2
预览结果