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?