Text data appears as 0 in my Pivot table - how do I display as tex

You can't display text fields as text in the data area. You could add
the field to the row area, where the text will be displayed, then use
another field in the data area to obtain a count of the occurrences.


Murray Snedden wrote:

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

You can't display text fields as text in the data area. You could add
the field to the row area, where the text will be displayed, then use
another field in the data area to obtain a count of the occurrences.


Murray Snedden wrote:

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

You can't display text fields as text in the data area. You could add
the field to the row area, where the text will be displayed, then use
another field in the data area to obtain a count of the occurrences.


Murray Snedden wrote:

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html