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