Pivot Table

[Doris Edwards]

Hello,
Have a Pivot Table where I COUNT the number of entries (in database)
according to four categories, see example below. I would like to Pivot table
to count the BLANKS as well, as if it were a category. Don't find any option
that allows me to configure this. Does it exist ?

doctor
doctor
pharmacist
pharmacist
blank (no entry)
blank (no entry)
nurse
nurse

 

[Debra Dalgleish]

If you add the Title field to the row area, and also add it to the Data
area, all four categories should appear, including (blank).

 

[Doris Edwards]

Thanks for your reply, but I am afraid what you suggest does not work. The
blanks appear as a category, but the field containing the number of entries
is blank.
Best regards. Doris, Geneva

 

[Debra Dalgleish]

Sorry Doris! To count the blanks you could add a column adjacent to the
list of titles, and enter an X in each row. Add the Title field to the
row area, and the X field to the data area.

Or, use a space character, or the formula ="", in the title field,
instead of leaving the cells blank. The pivot table will be able to
count those.