Exclude zeros from pivot table averages

[Matthew]

Would like to understand how to exclude zeros from pivot table averages;

a - 100
a - 100
a - 0

above should result in an avg of 100, not 66.7.

 

[Jim Thomlinson]

That is a source data problem. In our souce data Find and Replace all of the
0's with blanks (ensure you are doing an exact match!)...