Bringing over text fields into pivot tables
Just bring them into the Row area instead of the Data area. Since it will
automatically give you an "outline" format with subtotals, just right-click
on any row item, select "Field Settings" and select the "None" radio button
under "Subtotals" to turn off the outlining feature.
--
Please remember to indicate when the post is answered so others can benefit
from it later.
"Dil" wrote:
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.
|