Exclude zeros from pivot table averages
 

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.

Exclude zeros from pivot table averages
 

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!)...
--
HTH...

Jim Thomlinson


"Matthew" wrote:

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.