vba code for Pivot Table
 

I have written vba to generate a PT from a list of rows
in excel. I do not want to include in the PT the rows
that has a certain key field = zero but they still
appear. The key field contains an IF statement that
forces the value of one cell into it until an occurence
of a condition and then it is to contain zero. I cannot
work out how to programmically suppress it while it
contains zero. Any ideas