Text as Pivot Data Field

[LSMark]

Excel defines pivot a data field as "usually contains
numeric data, such as statistics or sales amounts, but it
can also contain text. Data from a data field is
summarized in the data area of a PivotTable or PivotChart
report."

I have a Pivot Table containing:

1 Row Field called: Name
1 Column Field called: Date
3 Data Field (2 numeric, 1 Text)

Everything comes in great except the text field is zero.
I'm guessing the reason is because the Pivot is forcing me
to perform a "Sumarize As" function like count, sum, ...

How can i get the text in too? Is there a way to change
the field settings or add a calculated field to do this

Thanks,
Mark

 

[Debra Dalgleish]

Text can't be displayed in the data area of a pivot table. You can
include text fields, but only as a numerical summary of the field.

If you have a copy of Microsoft Access, you could create a crosstab
query to summarize the data, and use the First or Last function to show
text.