Pivot Table Avg only >0.000???

  • Thread starter Thread starter Ken
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

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 Avg only when >0.000? 4
Pivot Table ... Suppress "0" Values? 2
Pivot Table Refresh? 1
Pivot table filter list - listing irrelevant subcategorys 1
Pivot Table Refresh? 2
Exclude zeros from pivot table averages 1
Pivot (Data Items "Count" vs "Sum") 2
pivot table - show ALL detail? 3

Back
Top