Count blanks in Pivot tables reports

[Guru]

As per this
http://office.microsoft.com/en-us/excel/HP052031161033.aspx?pid=CH010004401033

COUNTA will total only non blank items. I need to Count blanks also. What
option is available for this in Pivot tables?

 

[Debra Dalgleish]

The pivot table can't count blank cells, so if you put a field (e.g.
Product) in the row area, and Count of Product 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 Order 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 product field.