C
Castor
Hi,
I have a very urgent problem on hand that I cannot figure
out.
I have a query in Excel that is retrieving data from
Access. This query is then linked with a pivot table in
the same spreadsheet.
A sample record is
Origin Destination UnitID
Toronto Vancouver 5365
Now when I try to add the UnitID field as a coulumn in the
pivot table it gives me the message
"A field in your source data has more unique items that
can be used by the pivot table"
How can I fix this? If I have two records with the same
unit ID that I just want one to appear in the pivot. How
can I do that? Thanks a lot - Castor
I have a very urgent problem on hand that I cannot figure
out.
I have a query in Excel that is retrieving data from
Access. This query is then linked with a pivot table in
the same spreadsheet.
A sample record is
Origin Destination UnitID
Toronto Vancouver 5365
Now when I try to add the UnitID field as a coulumn in the
pivot table it gives me the message
"A field in your source data has more unique items that
can be used by the pivot table"
How can I fix this? If I have two records with the same
unit ID that I just want one to appear in the pivot. How
can I do that? Thanks a lot - Castor