I've got a table of about 100 columns and 80 rows. I'm creating a simple
pivot table to bring over whichever columns are appropriate for a given
report. Some of these fields are text columns, but I am struggling bringing
over text fields into the pivot table.

Does anyone know how to bring over values (vs. sum or count) and text values
into a pivot table?

Thanks so much.