Pivot Table Avg only >0.000???

K

Ken

Excel 2000 ... Pivot Table ... My Pivot Table AVGs are
being skewed down by an occassional "0.000" value
appearing in the Col.

Above said ... Is there a way to set the Pivot Table Field
to only AVG those values >0.000???

Thanks ... Kha
 
F

Fred

Ken,

You can make a helper column with
=IF(B2>0,B2,"")

You can use the same heading as the original, so it will be the heading you
want in the pivot table, and you can hide the column too. It may default to
COUNT for the function, which you can change to average.
 
Top