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


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

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.


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

What version are you using?

I have no problem with 4 row fields???

Ex2k

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


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

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


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

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?

"cer9" wrote:


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


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

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


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

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

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