Pivot table - text in values area

[Excel Chimp]

From the research I've done, it seems that pivot tables do not support text in the values area, period. **** this is frustrating!
Quite a bit of work has gone into aggregating this data, and it's so close, but the text fields are showing 0.

Have a look. Double-clicking on cell C5 (sheet 1) drills down into the individual record. Cell E2 (sheet 4) contains the text value I need--"Not Stated".
Is there any quick workaround to get this text value to showup in cell C5 of the pivot table?

Thanks for any input.

Excel Workbook
	A	B	C	D	E
3	Sum of Provision in Agreement	Description
4	Property	# of Units	Add'l Leasing Guidelines	Agreement Format:	Annual Reporting - Deadline:
5	2nd and Wall	0	0	0	0
6	4 Forty Flagler Village	218	0	0	0
7	44 Monroe	0	0	0	0
8	626 DeKalb	0	0	0	0
Sheet1

Excel Workbook
	C	D	E	F
1	Description	Property	Provision in Agreement	Section
2	Add'l Leasing Guidelines	2nd and Wall	Not Stated	0
Excel 2010 Sheet4

Excel 2010

 

[Firefly2012]

I don't believe so - you would need to add these fields as Row fields to you pivot table so they show up as the record's text values.

 

[Excel Chimp]

The source data has the field header names in column C, with the corresponding text data in another column (columns E and F).

I guess that's what is making it tricky...

Excel Workbook
	A	B	C	D	E	F
1	SheetNo	DescNo	Description	Property	Provision in Agreement	Section
2	1	1	Property Name:	88 West Apts.	88 West Apartments	0
3	1	2	Agreement Format:	88 West Apts.	Non-Greystar	0
4	1	3	Owner Name (Legal Entity)	88 West Apts.	KW Champaign Apartments, LLC	recitals
consolidated

Excel 2010

 

[Excel Chimp]

Seems that the only way to accomplish this task is for the field names (repeating in Column C below) to be transposed to columns with data underneath in rows.
Feedback?

 

[Excel Chimp]

EDIT: Seems that the only way to accomplish this task is for the field names (repeating in Column C below) to be transposed to columns with data underneath in rows, AND THEN (this is key) adding the field names to the row labels, tabular view.

Feedback?