If the field that contains blanks is in the Row area, add another field,
that contains data in every record, to the Data area.
For that field, change the Summary function to Count, and it will show a
count of the blank items.
ben****er2 wrote:
I cannot figure out why in my pivot table, it sums all the appropriate data,
but does not return a count of "blanks". This is a critical piece of
managing the data.
Any suggestions.
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html