I am creating my pivot table from multiple Excel files. For example:

(File 1)
custnbr custname sales detail yr 1
(File 2)
custnbr custname sales detail yr 2
(File 3)
custnbr custname sales detail yr 3

When I use the pivot table wizard and go to layout, it does not show me
column titles as some of the posts and links show, but just ROW, COLUMN,
VALUE.

What I am trying to end up in my pivot table is:

On Row Side:
custnbr custname
On Column Side:
sum sales dtl yr1 sum sales dtl yr2 sum sales dtl yr 3

I am getting the sums ok, but the custname is appearing on the COLUMN side.
I don't know how to not sum only that column.

If I try to change layout, it shows me only one COLUMN to drag to row side.
If I drag it, it moves ALL columns to row side.

Can you help?






"Debra Dalgleish" wrote:

Add customer name to the row area
Double-click on the customer name button
For Subtotals, choose None
Click OK

New Pivot Table User wrote:
I am new to pivot tables. My pivot table is summarizing by customer number
(under Row). How do I show the customer name next to the customer number?
When I try to move it there, it tries to summarize again.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html