non-numeric fields in pivot table

  • Thread starter Thread starter Jim Weiss
  • Start date Start date
J

Jim Weiss

Hi -

I'm trying to create a pivot table, but the data I'm
trying to display is non-numeric. Row headings will be a
feature number, column headings will be a customer, and
the data displayed will be text, eg Q1FY03, Q2FY04, etc.
But it appears all of the pivot table options are confined
to numeric calculations like sum, count, max etc. Is
there a way to just get a pivot table displaying the text
data and not the count, etc?

Thanks!
 
The data area of a pivot table can't show text. Perhaps you could create
a table on the worksheet, and use formulas to return the data.

Or, store the data in Microsoft Access, where you can create a crosstab
query, and use the First/Last functions to show text.
 
Back
Top