Pivot Table and Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table data 1
Pivot Table Data 1
Pivot Table 2
Surpressing rows and columns with zero values in a pivot table 1
Excel Pivot Table problem 8
Pivot Table Formula 1
Copying pivot table 2
Pivot table - Problem with % 5

Back
Top