• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 406
  • Last Modified:

Excel Pivot Table Question

I have set up a pivot table in the attached workbook.  I would like for the value(text) to show in the place of the count at each date and time point.  I cannot determine how to do this.

Thank you
0
mcarsonsr
Asked:
mcarsonsr
  • 2
  • 2
  • 2
1 Solution
 
FlysterCommented:
There is no file attached!

Flyster
0
 
mcarsonsrAuthor Commented:
File attached now.  Thanks
Employee-Listing.xls
0
 
Jerry PaladinoCommented:
mcarsonsr,

You are wanting to display the names of each person in the interview schedule based on the date and time.   However, only numbers will display in the "Value" portion of a pivot table.   If you want the names to display you will need to use "Last Name" in either a Row or Column and not in the Value section.

Thanks,
Jerry
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
FlysterCommented:
I would like for the value(text) to show in the place of the count at each date and time point.
What value are you looking for? There does not appear to be a value field in your table.
0
 
mcarsonsrAuthor Commented:
Instead of a count of the last names at each time and date data point, I would like the last name to appear.

Research seems to indicate it cannot be done with a pivot table.

I am trying to verify that and also determine whether there is another automated way to produce such a view of the data.

Thank you
0
 
Jerry PaladinoCommented:
mcarsonsr,

As I mention above, the Last Name will not display in a Value field in a Pivot Table.  Only numbers will display in a Value field.    The attached file has a sample pivot table with Last Name as a ROW field.   This provides the same data you are requesting by (Date and Time) but the formatting is slightly different.

Thanks,
Jerry
Employee-Listing.xls
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now