Pivot Table Layout question
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
|