I am using a pivot table to display data ina user friendly way rather than to
really analyze anything. I want to get the "value" of a text field as a data
element in a pivot table. There is only a single value for each of 5 years
for 150 different programs. I thought by asking for MAX value i could fake
it out, but it comes back with 0's rather than the text value. What I want is
something like this:
year 1 year 2 year 3 etc

progarm 1 satisfac excellent fair
program 2 fair poor fair
program 3

You can only count text values in a pivot table. How does your source data
table look?


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"LIZLYNCH" wrote in message
...
I am using a pivot table to display data ina user friendly way rather than
to
really analyze anything. I want to get the "value" of a text field as a
data
element in a pivot table. There is only a single value for each of 5 years
for 150 different programs. I thought by asking for MAX value i could
fake
it out, but it comes back with 0's rather than the text value. What I want
is
something like this:
year 1 year 2 year 3 etc

progarm 1 satisfac excellent fair
program 2 fair poor fair
program 3