Solved

Excel Pivot Table Question

Posted on 2013-06-22
6
361 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
  • 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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
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;…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
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…

831 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