View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashley1432 Ashley1432 is offline
external usenet poster
 
Posts: 4
Default 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