I have several pivot tables in a workbook. The person who uses this workbook
couldn't reconcile the data, and on investigation, it isn't doing what I
expected so I thought I'd see if someone here could help me understand what
is going on.

The pivot table is fairly simple- the left side is the data in Column E
(Event) and across the top of the pivot table I have the data from Column B
(location)

There are two rows of worksheet data that I think should be showing up in
the pivot table but aren't; in both of those rows, the cell in Column E
(event) is blank. There is a row in the pivot table labelled "(blank)" where
I'd expect them to show up.

If any text (even a space) is entered in those blank cells in Column E,
those counts /do/ show up in the pivot table when it is refreshed, so I know
that the location is working/matching properly. When I remove the event,
they dissapear- they don't show up as entries for that location in the
(blank) row.

Is there a reason why a pivot table might not include rows where there is a
match on one factor, but a blank cell for the other? Ultimately, I need to
figure out how to get an accurate count; if we have several blanks per month
that can really throw off our planning if they don't show up in our reports.

Thank you for any ideas or suggestions,
Keith