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 |
