I suspect the problem is that you have too many different product
descriptions. The table is trying to summarize the data for each unique
instance for each field you have for "Product."

I recommend you rethink whether you really need that field. Instead, do
it by product type only. Once you get that to work, double click a
product code field and when it asks you how to expand - try choosing
product. this might work, but it could be a huge report, defeating the
intent of the pivot summary.
-Bill



cer9 wrote:
cer9 Wrote:
The first column in the table is full of sales reps. the next column
shows customers that have bought from the sales rep. the third column
shows products that the customers have bought. and the column i'm
trying to add is a single letter (exp. x,y, or z) classification of the
product.

The data is basicly revenues and margins by product. I want it to look
like this:

columns: {Rep} {Customer} {Product} {producttype} {QtyPurch}
{Rev} {NetMargin} {NM%}

Data: {repA} {CustA} {ProdA} { X }
{ 100ft } {1,000} { 200 } {20%}


--
cer9
------------------------------------------------------------------------
cer9's Profile: http://www.excelforum.com/member.php...o&userid=33651
View this thread: http://www.excelforum.com/showthread...hreadid=534263