Pivot Table and Text
 

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.

Pivot Table and Text
 

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