Using Excel 2003, I am creating a pivot table using customer data similar to
the following:

Customer Location Interface Code
11 Word 123
12 Excel
13 Outlook 456
21 Word
22 Excel ABC
23 Outlook XYZ

I am placing the Customer Location in the row area, the Interface in the
column area and the Code in the data area. I would like the Code to show in
the pivot table as the "123", "456", "ABC", and "XYZ". I don't want a count
of those values, I just want the actual values to print in the pivot table.
Is this possible?

Thanks for any help!
Tom

PivotTables are designed to aggregate data so the data area can only contain
some kind of summation (or count, or standard devitation, etc.)

ERR229


"Tom Pivot!" wrote:

Using Excel 2003, I am creating a pivot table using customer data similar to
the following:

Customer Location Interface Code
11 Word 123
12 Excel
13 Outlook 456
21 Word
22 Excel ABC
23 Outlook XYZ

I am placing the Customer Location in the row area, the Interface in the
column area and the Code in the data area. I would like the Code to show in
the pivot table as the "123", "456", "ABC", and "XYZ". I don't want a count
of those values, I just want the actual values to print in the pivot table.
Is this possible?

Thanks for any help!
Tom