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

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.

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

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.

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

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

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.

--
Regards

Roger Govier


"SEF" wrote in message
...
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.