Subtotals in a Pivot Table

A

Ashley1432

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table 0
Pivot Table GETPIVOTDATA 2
Hlookup and sum noncontiguous numbers 1
Running Balance (Debit and Credit) in Access 2007 3
Don't show all Pivot table subtotals 1
Two Totals from the same column 2
Pivot Table with Data Model Connection - getpivotdata reference issue 0
grouping dates in a pivot table 1

Top