Solved

Excel Pivot Table Question

Posted on 2013-06-22
6
381 Views
Last Modified: 2013-06-23
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
Comment
Question by:mcarsonsr
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 22

Expert Comment

by:Flyster
ID: 39268680
There is no file attached!

Flyster
0
 

Author Comment

by:mcarsonsr
ID: 39269043
File attached now.  Thanks
Employee-Listing.xls
0
 
LVL 16

Expert Comment

by:Jerry Paladino
ID: 39269218
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 22

Expert Comment

by:Flyster
ID: 39269580
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
 

Author Comment

by:mcarsonsr
ID: 39269684
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
 
LVL 16

Accepted Solution

by:
Jerry Paladino earned 500 total points
ID: 39269873
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question