Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is it possible to have text as a result in a pivot table? For example, if I
have an employee and a supervisor and I want to link these to their task/duties. Or maybe I have an employee with multiple jobs, each with a different duty. If there isn't an option in a Pivot Table, maybe somebody could recommend something else. Thanks a lot. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You could display the text fields in the Row and Column areas, and show
a count of the records in the data area. For example, put employee and supervisor in the row area, task in the column area, and another copy of employee in the data area, as count of employee. James O wrote: Is it possible to have text as a result in a pivot table? For example, if I have an employee and a supervisor and I want to link these to their task/duties. Or maybe I have an employee with multiple jobs, each with a different duty. If there isn't an option in a Pivot Table, maybe somebody could recommend something else. Thanks a lot. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Show text data in excel pivot table | Excel Discussion (Misc queries) | |||
Pivot table formats text data with 2 decimals | Excel Discussion (Misc queries) | |||
get SQL Server text data type into Excel pivot table | Excel Discussion (Misc queries) | |||
How to create a Pivot table from text file with more than 65000 rows? | Excel Discussion (Misc queries) | |||
Pivot Table - Wrapping Text | Excel Discussion (Misc queries) |