Código SQL [-]SELECT medicamento, sum(case when extract(month from fechapago) =1 then valor else 0) as ENERO, sum(case when extract(month from fechapago) =2 then valor else 0) as FEBRERO, ... GROUP BY medicamento
SELECT medicamento, sum(case when extract(month from fechapago) =1 then valor else 0) as ENERO, sum(case when extract(month from fechapago) =2 then valor else 0) as FEBRERO, ... GROUP BY medicamento