Seems weird that pivot tables won't count blank values. But thanks for your
suggestion.

"Debra Dalgleish" wrote:

The pivot table can't count blank cells, so if you put a field (e.g.
Inquiries) in the row area, and Count of Inquiries in the data area, the
(blank) item will show nothing in the data area.

However, if you add a different field to the data area, you may see the
correct count. For example, if the Date field always has a value, add
that to the data area, and summarize by Count. The pivot table will then
show the count of records with a blank Inquiries field.

Eric wrote:
I'm doing a simple pivottable, showing a count of the different values in one
field of a table. The pivottable shows all the values, including "(blank)".
All the counts are shown, as expected, with the exception of the "(blank)"
value, which shows a blank instead of a count.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html