Text and Pivot Tables

[JohnStevensInc]

I am creating a pivot table based on the following list:

2004.Case Review.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Audit	Name	Month	Year	UnitNumber	Assemble	Finish	Paint	Check1	Inonize	Check2	Finalize	Check3	Score
2	1	Jones,Frank	January	2004	1000000000-1-5	1	0	1	n/a	1	1	1	1	86%
3	2	Smith,Joe	January	2004	1000000000-1-6	1	0	0	0	1	1	n/a	n/a	50%
4	3	Tran,Tho	January	2004	1000000000-1-7	1	1	n/a	1	1	0	1	1	86%
Review Data

I would like the pivot table to look like:

2004.Case Review.xls
	A	B	C	D	E	F	G	H	I	J	K
1	Audit
2
3	Year	(All)
4	Month	(All)
5
6		Data
7	Name	CountofUnitNumber	SumofAssemble	SumofFinish	CountofPaint	CountofCheck1	SumofInonize	SumofCheck2	CountofFinalize	CountofCheck3	SumofScore2
8	Jones,Frank	1	1	0	1	1	1	1	1	1	0.86
9	Smith,Joe	1	1	0	1	1	1	1	1	1	0.5
10	Tran,Tho	1	1	1	1	1	1	0	1	1	0.86
11	GrandTotal	3	3	1	3	3	3	2	3	3	2.21
January

However, I would like it to reflect the data exactly how it appears on the data sheet. I can't figure out any way to make the "n/a" or the Unit Number to appear exactly like they are on the data sheet. I think it is because they are text and not numbers. Any way to have them appear in the pivot table exactly as they are on the data sheet?

 

[JohnStevensInc]

Anybody? Help?

 

[BrianB]

If you mean that you want to change the column headers .....
right click the header in the PT, select Field from the dropdown menu ........