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

In the data area, add a field that will always contain an entry, and set
that field to Count. If you've added Event to the data area, the blank
cells aren't counted, so you won't know how many events are missing.

Keith R wrote:
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




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html