Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Data as Text
Hello,
Is it possible to display information in the "Data" area of a pivot table as the actual data text instead of a numeric count, sum, average, etc? I have data that contains a days, names, and positions. I would like to show the day on the left as rows, the names and columns across the top, and the position in the data portion, something like this: Joe Sam Bob Mon Lathe Drill Saw Tue Drill Saw Lathe Wed Lathe Saw Drill Currently, I am only able to achieve something close as follows: Joe Sam Bob Mon Lathe 1 Drill 1 Saw 1 Tue Lathe 1 Drill 1 Saw 1 Is there any way to get the text data instead of numeric in to the data portion of the pivot? Thank you Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting text data from a pivot table | Excel Worksheet Functions | |||
pivot-like chart for text data | Excel Discussion (Misc queries) | |||
using pivot table to crosstab text value data | Excel Discussion (Misc queries) | |||
text in data area on pivot table | Excel Discussion (Misc queries) | |||
Pivot table - Text in Data field | Excel Discussion (Misc queries) |