I created a Pivot Table where everything works except for one column. The
column show the size of products(1CT, 100oz....). I have the field set up to
summarize by MAX. I tried changing the format of this field from General to
Text but that did not do anything. I also tried doing a Text to Column in
the datasheet column for this field, but that did not work either.

Any ideas?