Using Pivot Table to display text values

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I am trying to use an Excel Pivot Table to display the
associated text data (there is only one value cell for
each row and column combination). The data is currently
displayed as zeros in the Pivot Table since it is trying
to COUNT, rather than just display the text. Is there a
way to turn off the Count function without using another
formula such as SUM or AVERAGE?
 
Text can't be displayed in the data area of a pivot table. You have to
use one of the available summarize options (Count, Sum, etc.), but you
could format the cells with white font, so the results aren't visible.
 
Back
Top