Count blanks in Pivot tables reports
 

As per this
http://office.microsoft.com/en-us/ex...CH010004401033

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

Count blanks in Pivot tables reports
 

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.

Guru wrote:
As per this
http://office.microsoft.com/en-us/ex...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
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com