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