Hi. I want to pivoting issued and paid amount for month. I created pivot table like this. for example
| paid_amount | | | | | | | | | issue_amount | | | | | | | | |
paid_date | Dec 2011 | Jan 2012 | Feb 2012 | Mar 2012 | Apr 2012 | May 2012 | Jun 2012 | Aug 2012 | - | Dec 2011 | Jan 2012 | Feb 2012 | Mar 2012 | Apr 2012 | May 2012 | Jun 2012 | Aug 2012 | - |
issue_date | 40,878.00 | 40,909.00 | 40,940.00 | 40,969.00 | 41,000.00 | 41,030.00 | 41,061.00 | 41,122.00 | | 40,878.00 | 40,909.00 | 40,940.00 | 40,969.00 | 41,000.00 | 41,030.00 | 41,061.00 | 41,122.00 | |
Jan 2012 | 400.00 | 224,760.00 | 116,440.00 | 3,755.00 | 1,010.00 | 2,520.00 | 200.00 | 180.00 | 0.00 | 400 | 224760 | 116440 | 3755 | 1010 | 2520 | 200 | 180 | 2155 |
for paid amount it is ok. It show amount for each month. But for issued_amount I do not want to see devided by month. just want to see total. How can I do this?