Extracting unique items in Excel Pivot Table
Posted on 2012-03-30
I'm trying to create a pivot table from my raw data but it is always giving me a message everytime I drop a field in the table such as the name or id number.
" A field in your source data has more unique items than can be used in a pivot table report". Is there any way I can go around this? Note: The raw data has duplicate names but my understanding is it should summarize them along with the other same names.