| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table: displaying text instead of number; can it
okay, this is what I'm trying to do.
In the column I have Job Position, Row I have dates and in the data I want Employee's name. So I'll end up with a table that will show every day who was in what position. Does the data have to be a number, can it be text? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table: displaying text instead of number; can it
The stuff in the data area is limited to numeric summaries--count, average, sum,
.... The stuff in the page, row, column area can be text, though. Allen wrote: okay, this is what I'm trying to do. In the column I have Job Position, Row I have dates and in the data I want Employee's name. So I'll end up with a table that will show every day who was in what position. Does the data have to be a number, can it be text? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table: displaying text instead of number; can it
Sorry to hear that Thanks "Dave Peterson" wrote: The stuff in the data area is limited to numeric summaries--count, average, sum, .... The stuff in the page, row, column area can be text, though. Allen wrote: okay, this is what I'm trying to do. In the column I have Job Position, Row I have dates and in the data I want Employee's name. So I'll end up with a table that will show every day who was in what position. Does the data have to be a number, can it be text? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Show text data in excel pivot table | Excel Discussion (Misc queries) | |||
| Change Data In Pivot Table | New Users to Excel | |||
| convert excel list to pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
