View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BilgeRat BilgeRat is offline
external usenet poster
 
Posts: 2
Default 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