Your question is a little thin but here goes.

Place the sites in the right most column. Place the codes across the top.
Place the codes in the data section. That should give you a Matrix of all of
the codes and which locations are using those code.

Note that pivot tables are designed to aggregate data. They are not designed
to show text.

--
HTH...

Jim Thomlinson


"RW" wrote:

How do I get the value of data to show instead of the sum, count, min, etc?
I have a list of code values for items. The list contains A through L and 1
through 9. This is for thirty-two different sites and they do not all use
the same code for the same item. I am trying to display a matrix of the
items and the codes used by each site. When I add the code field to the data
items on my pivot table it will not diaply the actual code only the SUM etc.