Exclude zeros from pivot table averages

  • Thread starter Thread starter Matthew
  • Start date Start date
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.
 
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!)...
 
Back
Top