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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Shows Only Zeros 3
Pivot table bottom ten filter with conditions 2
Need the grand total pivot table filtered worksheet? 1
PIVOT TABLE SUM OF AVERAGES 1
Calculated Item causes undue repitition in pivot table 2
Exclude data from Pivot Table based on filter? 3
pivot table data 1
PIVOT Display is WRONG 3

Top