G
Guest
Hi,
We have a pivot table that summarises work done for any given date. The
spreadsheet includes a tab for the raw data which is grabbed from an external
database.
The pivot table is, hopefully, just a summary of that raw data but in a more
user friendly look.
The problem is that entries on the raw data tab are missing from the pivot
table.
I've checked that the pivot table includes these rows and that there are no
filters in place on the pivot table, so all available data should be
displayed.
The missing data all seems to have one thing in common - the type of work is
listed as "Inbound email" and all data that shows on the pivot table is
"Outbound email". When I check the filter of the column we have labelled
"Contact Type", only the "Outbound email" option is listed.
I don't know how a pivot table can exclude data that is listed on the raw
data tab. Is anyone able to offer a suggestion as to why this is happening
and how I can have the pivot table include all data?
Thanks in advance,
Scott
We have a pivot table that summarises work done for any given date. The
spreadsheet includes a tab for the raw data which is grabbed from an external
database.
The pivot table is, hopefully, just a summary of that raw data but in a more
user friendly look.
The problem is that entries on the raw data tab are missing from the pivot
table.
I've checked that the pivot table includes these rows and that there are no
filters in place on the pivot table, so all available data should be
displayed.
The missing data all seems to have one thing in common - the type of work is
listed as "Inbound email" and all data that shows on the pivot table is
"Outbound email". When I check the filter of the column we have labelled
"Contact Type", only the "Outbound email" option is listed.
I don't know how a pivot table can exclude data that is listed on the raw
data tab. Is anyone able to offer a suggestion as to why this is happening
and how I can have the pivot table include all data?
Thanks in advance,
Scott