Solved

Extracting unique items in Excel Pivot Table

Posted on 2012-03-30
1
1,050 Views
Last Modified: 2012-04-05
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.

Thank you.
0
Comment
Question by:samonet
1 Comment
 
LVL 80

Accepted Solution

by:
byundt earned 500 total points
ID: 37788483
Excel 2003 is limited to 32500 unique items in a PivotTable field.

Excel 2007 and 2010 allow 1,048,576 unique items in a PivotTable field.

If you aren't able to switch to a later version of Excel, you will need to do some grouping of the names if you want to produce a PivotTable report. You can do so with a formula, and would use the results of that formula as the field items.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
This collection of functions covers all the normal rounding methods of just about any numeric value.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now