Working Excel 2007 pivot table, want just text to show on the pivo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel 2007 work sheet with Columns A, B and C. Using the Pivito
Wizard, I put drag "Column A" into the "Row Labels" box and "Column B" into
the "Column Labels" box.

My question is, when put "Column C" into the "Values" box, is it possible to
have just the text inserted and no mathematical function performed.

Is this Excell Pivot Table the correct function to use or is there another
means excel to accomplish this task.
 
Hi Sef,
My question is, when put "Column C" into the "Values" box, is it possible to
have just the text inserted and no mathematical function performed.
Click to expand...

Maybe you get what you are after by dragging col C into the row labels too?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
Hi

The Values area will not show Text.
If you add a field contain Text to the Values area, the PT will give a
Count of the items.
 
Back
Top