software

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 quot;123quot;, quot;456quot;, quot;ABCquot;, and quot;XYZquot;. 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.)

ERR229quot;Tom Pivot!quot; wrote:

gt; Using Excel 2003, I am creating a pivot table using customer data similar to
gt; the following:
gt;
gt; Customer Location Interface Code
gt; 11 Word 123
gt; 12 Excel
gt; 13 Outlook 456
gt; 21 Word
gt; 22 Excel ABC
gt; 23 Outlook XYZ
gt;
gt; I am placing the Customer Location in the row area, the Interface in the
gt; column area and the Code in the data area. I would like the Code to show in
gt; the pivot table as the quot;123quot;, quot;456quot;, quot;ABCquot;, and quot;XYZquot;. I don't want a count
gt; of those values, I just want the actual values to print in the pivot table.
gt; Is this possible?
gt;
gt; Thanks for any help!
gt; Tom