Subtotals in a Pivot Table
 

I have a pivot table that sums the activity of different items throughout
different months. Many times an amount will come in as a positive amount and
then leave the next month with a negative amount, leaving the total for that
item as zero for the year. Is there a way I can subtotal my pivot table to
not show items that have a zer balance for the year? See the example below:

Current:
Item Month 1 Month 2 Total
1 300 200 500
2 150 -150 0
3 200 -200 0

Would Like:
Item Month 1 Month 2 Total
1 300 200 500
Zero Items 350 -350 0

Subtotals in a Pivot Table
 

Excel 2007 PivotTable
Value Filter, Groups
Two ways.
http://www.mediafire.com/file/tj4mgy...08_17_09a.xlsx