Query Komulatif Capian PD

SELECT
pd.pd as pd,
id_renja,
id_skpd,
SUM(pagu) as pagu,
realisasi_uang,
realisasi_uang / pagu * 100 as pk,
pf,
COUNT(Distinct tb_renja.id_program) as tp,
COUNT(Distinct CASE WHEN tb_renja.cekter = 'true' THEN tb_renja.id_program END) as pt,
COUNT(Distinct tb_renja.kegiatan) as tk,
COUNT(Distinct CASE WHEN tb_renja.cekter = 'true' THEN tb_renja.kegiatan END) as kt
FROM tb_renja
LEFT JOIN (SELECT id_renja, sum(realisasi_uang) as realisasi_uang,sum(pf) as pf
           FROM rab
           GROUP BY id_renja)
           a USING (id_renja)
RIGHT JOIN pd ON tb_renja.skpd = pd.pd
WHERE pd.pd_id
GROUP BY pd.pd