Text in Pivot Tables

[Gregc.]

Hi

When doing a Pivot Table is it possible to have text instead of numbers
in the table? If so, how can this be done.

Greg

 

[Dave Peterson]

Not in the data area.

You can have text in the row, column or page fields.

 

[Peo Sjoblom]

If you use text it defaults to count, but that's it

Peo

 

[Dave Peterson]

Not quite the same thing as Text IN the pivottable, though.

It is using text to create the pivottable, but doesn't display text in the data
field.

 

[Gregc.]

Thanks for your help. Apology for the duplication above.

Greg