I received a wb created by someone else which had PT data laid out as below:

| |Data
Customer name | Part # | Sales$ | COGS$ | Margin$ |
AnyCo | XYZ | $123 | $99 | $24


When I lay this out I get:

Customer name | Part # | Data
AnyCo | XYZ | Sales$ | $123
| COGS$ | $99
| Margin$ | $24

How do I get the data fields to all line up in a row?

Thanks

Drag the grey Data button to the right, onto the cell that says "Total"
There's a picture he

http://www.contextures.com/xlPivot02.html

BilgeRat wrote:
I received a wb created by someone else which had PT data laid out as below:

| |Data
Customer name | Part # | Sales$ | COGS$ | Margin$ |
AnyCo | XYZ | $123 | $99 | $24


When I lay this out I get:

Customer name | Part # | Data
AnyCo | XYZ | Sales$ | $123
| COGS$ | $99
| Margin$ | $24

How do I get the data fields to all line up in a row?

Thanks


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Feeling stupid - That was easy. thanks so much!!!

"Debra Dalgleish" wrote:

Drag the grey Data button to the right, onto the cell that says "Total"
There's a picture he

http://www.contextures.com/xlPivot02.html

BilgeRat wrote:
I received a wb created by someone else which had PT data laid out as below:

| |Data
Customer name | Part # | Sales$ | COGS$ | Margin$ |
AnyCo | XYZ | $123 | $99 | $24


When I lay this out I get:

Customer name | Part # | Data
AnyCo | XYZ | Sales$ | $123
| COGS$ | $99
| Margin$ | $24

How do I get the data fields to all line up in a row?

Thanks


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html