Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
How do I find the "Show Pages..." Pivot table feature in 2007? | Excel Discussion (Misc queries) | |||
Pivot Table Office 2007 Beta show Top/Bottom features | Excel Discussion (Misc queries) | |||
Show text data in excel pivot table | Excel Discussion (Misc queries) | |||
how do i show text in the data field of a pivot table? | Excel Discussion (Misc queries) |