Exclude zeros from pivot table averages

M

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.
 
J

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