View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad Brad is offline
external usenet poster
 
Posts: 846
Default text data in pivot table reports

I only have text data in my excel spreadsheet. I have a small group of
managers and each is assigned to several employees. The employee information
contains last name, first name, address, telephone. When i create a pivot
table and use the manager as a column heading and the last name as data i
only get count totals and not the employee name. How do i get the employee
names to appear as data??