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
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