Shane,

Thanks for the suggestion. However, it did not resolve my issue. It was
already set up the way you suggested.

Take care,

Jeff

"Shane Devenshire" wrote:

Hi,

Try this, with the pivot table selected choose PivotTable, Table Option and
check For Empty cells show, don't put anything in the adjacent box and click
OK.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Jeff" wrote:

Hi all,

I have a pivot table where I created a calculated field that averages three
of the fields in the pivot table. My problem is that it averages the "blank"
(which are created from blank fields in the source data) fields instead of
ignoring them. How can I average the fields in a Pivot Table and not include
the blanks in the average?