Pivot Table Help

C

cer9

I'm trying to create a pivot table that needs more than 3 fields in th
ROW section. When I try to drag the last field in I get an erro
message saying I have too many fields. The fourth field is simply
letter designation for the third field. Is there a way to get th
letters to show up in the data section? or any other way around thi
problem? i can provide more specifics on the table if that helps
 
C

cer9

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.
 
C

cer9

its microsoft office 2000 sr-1 professional. i have used four row
fields too... i don't know why this is not working.
 
D

Dominic

you know, i remember once getting that message too. i was in "layout" view. i
went ahead and clicked "finish" to create the pivot table. then, from the
table view, i dragged a fourth field to the row area and it worked fine.

will that work?
 
C

cer9

no, that brings up the same error message. i have a feeling it may b
because the table is too large... i'm looking in to other ways to solv
this. unless someone has a better idea.:mad
 
C

cer9

cer9 said:
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.
Click to expand...

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%}
 
B

Bill

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
 
Top