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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Data as Text
Hi Tommy
The closest you will get is to Drag Day to Row area, followed by Name to Row Area, followed by Tool to Row Area, then drag tool again to Data area as Count of Type Double click on Day heading and set Subtotals to None. Do the Same for Name. Right click on any cell in the PT Table Optionsde-select Grand Totals by Column What you would end up with would be Day Name Tool Total Mon Bob Saw 1 Joe Drill 1 Sam Lathe 1 Tue Bob Lathe 1 Joe Drill 1 Sam Saw 1 Wed Bob Saw 1 Joe Lathe 1 Sam Drill 1 You could hide the column containing Total-- Regards Roger Govier "tommcbrny" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Data as Text
Excel 2007 Pivot Table
Fill with text. Suitable for simple PTs. No code. http://www.mediafire.com/file/yjhm4z...03_19_09a.xlsx |
Reply |
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) |