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
 
Ad

Advertisements


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


Top