MAPPING LOAD

[upaliwije]

Hi

I attach herewith my sample data model where the output report is follows

PAID_MONTH	2015-01	2015-01	2015-05	2015-05
PROV_MONTH	sum(PROVISION_AMOUNT)	sum(PAID_AMOUNT)	sum(PROVISION_AMOUNT)	sum(PAID_AMOUNT)
2014-11	150,000	0	-	-
2015-01	152,100	0	-	-
2015-02	46,600	241,300	-	-
2015-04	-	-	50,000	75,000
2015-05	-	-	25,000	0
Total	348,700	241,300	75,000	75,000

But the report I want should look like as follows  Pls help me

PAID_MONTH	2015-01	2015-01	2015-02	2015-02	2015-05	2015-05
PROV_MONTH	sum(PROVISION_AMOUNT)	sum(PAID_AMOUNT)	sum(PROVISION_AMOUNT)	sum(PAID_AMOUNT)	sum(PROVISION_AMOUNT)	sum(PAID_AMOUNT)
2014-11	150,000	0			-	-
2015-01	152,100	241,300			-	-
2015-02	46,600		46600	46600	-	-
2015-04	-	-			50,000
2015-05	-	-			25,000
Total	348,700	241,300	46600	46600	75,000	75,000