Hi,

My pivot table has three "amount" columns for various products representing
1) 2012 sales
2) 2013 sales
3) 2012 collections

Product Category Amount
Bananas Sold 2012 $9,861.00
Grapes Sold 2013 $5,109.00
Nectars Paid 2012 $(3,350.00)
Bananas Sold 2012 $1,817.00
Oranges Sold 2013 $4,355.00
Pears Paid 2012 $(4,821.00)
Plums Sold 2012 $4,433.00
.....

The pivot table looks like this:

Sum of Amount Category
Product Sold 2012 Paid 2012 Sold 2013 Grand Total-Unpaid 2012
Apples 18,958 -17,958 7,440 1,000
.....

and the grand total includes 2013 sales.

I would like to keep 2013 sales in the pivot table, but exclude them from the Grand Total, which I would then rename as "Unpaid (overpaid) 2012."

So, in this example, I would like my grand total column to be 1,000, instead of the calculated amount 8,440.

Thanks,
MHL