Pivoting both expended and collapsed

Thu, 30 Aug 2012 05:44:28 GMT

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?

topic Pivoting both expended and collapsed in QlikView

Pivoting both expended and collapsed