Consider the table below. If you do a pivot table summing the qty of
Product, you end up with abc, with a net of 0, and ast with a qty of 0 also.
If I wanted to filter out results in the pivot table that were equal to
zero, how would I do that? I cannot find a way to set a filter, such as you
can do with Data, Filter, Auto Filter, and then filtering out the unwanted
values. It looks like to me that you should be able to do this without doing
an edit copy, and edit paste of the pivot table table into another sheet and
then setting up an Auto Filter in the way described above.



Product Qty
abc 6
abc -6
xyz 7
ast 0