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