Pivot table values
 

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.

Pivot table values
 

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.

Pivot table values
 

Excel 2007
This converts Pivot Table count data to
a Table with source text, using a macro.
http://www.mediafire.com/file/ww4mk0znmz5/02_27_09.xlsm