VBA to allow multiple value filters in a pivot table

Hello,

I'm trying to figure out how to add multiple value filters to a pivot table in Excel 2010. I'm using this particular pivot table to track purchase order item quantities. So the pivot table shows item sums in each row for each purchase order.

When refreshed, I want the pivot table to remove any purchase order whose sum of all items is now 0.

What I tried so far:
1. I tried, without VBA, using pivot table options to display the 'grand total per row' but because each item is a different name it will not display a grand total per row.
2. I won't get into great code detail but basically using VBA I tried valuefilters.add with the x1ValueIsGreaterThan:=0 per each item name but that isn't working.

Any suggestions, if possible?

Thanks in advance!

I decided to avoid the whole VBA issue and added a SUM column to my purchase order list. Then added that sum column to the pivot table and have the value filter 'greater than 0' use the SUM column. Done!