I am trying to create a pivot table by importing data from an external
source. It is essentially a list of thousands of products and their
respective prices. However, when I try to add the column 'products', I
receive an error message that states: "A field in your data has more unique
items than can be used in a PivotTable report. Microsoft Office Excel amy not
be able to create the report, or may create the report without the data from
this field."
I do not know how to fix this.
I would appreciate any help.