Pivot Table

  • Thread starter Thread starter Doris Edwards
  • Start date Start date
D

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
 
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).
 
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
 
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.
 
Back
Top