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.