Pivot Table limiting data
I'm not sure where to post this, as I am quite new here, so I apologize in advance if this is off-topic for this forum.
I am creating a Revenue Analysis for our company to use to sort customer data by amount, monthly, quarterly, yearly, etc. etc. etc. The Pivot Table works very well, however, I have found that after I input all of the customer data, it restricts the output in the pivot table and merely gets a sum of all of the inputs. As you can imagine, this doesn't prove of much use when you are looking at data for more than 400 customers (that's just for one market!). Is there some restriction on the number of inputs that can be fed into the Pivot Table? I have found that it works well with a smaller sampling of data, but once I start looking to add a substantial number of customers data, it fails.
Does anyone have any advice on this or perhaps a template that I could use to get acquainted with what I am hoping to accomplish? I am using MS Office Ultimate 2007 and my level of knowledge with Excel can be described as fundamental with a working knowledge of some of the advanced capabilities.
Welcome to the board
Are you using dynamic ranges?
Do you refresh the PT ?
Thanks for the feedback!To answer the question(s):
Dynamic Ranges are being used and yes, the table is refreshed. After some experimentation, I can describe the issue as follows:
There are well over 1,000 customers that I am trying to use data from for this table. I can get around 200 customers into the table with no issue, however, when I try to fit them all into the pivot table, it simply doesn't work, it just summarizes the data and doesn't even allow me to view the customer column heading - it just gives me the total number of customers that I have input rather than showing them individually.
I'm sure it's just something I'm overlooking, but somewhere between 200 and 1000 customers, something is getting out of whack. Problem is, I can't determine what is causing it!
Still not having luck tracking this one down.
Have you tried making a PT of the last 800 ( those who don't work)?
Could you post your data?
Last edited by arthurbr; 06-01-2007 at 02:35 AM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1