Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TEXT on a Pivot table Question
When I am looking at the Worksheet where I am building my pivot table,
there is a section labeled "Drop Data Items Here" I have a Source which has discrete items, there will be nothing to total, average, or otherwise apply mathmateics to. I want to put a TEXT field in this area, and have it display that text. Anything I have tried forces some kind of number out of it. Any Ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
TEXT on a Pivot table Question
In a pivot table, you can't show text in the data area, as you can in an
Access crosstab report. You can add the fields to the row area, where the text will be visible, then add fields to the data area, to show the count of the row field items. Phil Smith wrote: When I am looking at the Worksheet where I am building my pivot table, there is a section labeled "Drop Data Items Here" I have a Source which has discrete items, there will be nothing to total, average, or otherwise apply mathmateics to. I want to put a TEXT field in this area, and have it display that text. Anything I have tried forces some kind of number out of it. Any Ideas? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) | |||
Pivot Table Question | Excel Worksheet Functions | |||
Pivot Table Question | Excel Discussion (Misc queries) |