Pivot Table with Text
 

Is it possible to have a pivot table return a non-arithmetic value? What I
have done is create a table of Date, Day, Week, Month, Year, Name 1, Name 2,
Name 3, Name 4. The pivot table has the days across the top (Monday,
Tuesday, ...), with rows being "weeknum"bers (26, 27, 28), and page controls
being month and year. So what I am after is filling in the name fields with
peoples names (Mary, Joe, Steve, ...), and having them display in the days
of the week that they have scheduled to work. Is this possible?

Dave Nelson

You can put text in the Page field, row field, or column field. But you can't
put the actually text in the data field.



David Nelson wrote:

Is it possible to have a pivot table return a non-arithmetic value? What I
have done is create a table of Date, Day, Week, Month, Year, Name 1, Name 2,
Name 3, Name 4. The pivot table has the days across the top (Monday,
Tuesday, ...), with rows being "weeknum"bers (26, 27, 28), and page controls
being month and year. So what I am after is filling in the name fields with
peoples names (Mary, Joe, Steve, ...), and having them display in the days
of the week that they have scheduled to work. Is this possible?

Dave Nelson

--

Dave Peterson

As Dave Peterson said, you can't put text fields into the data area as text.

Perhaps you could use DataFilterAutoFilter instead, and filter by year
and month, to see the scheduled names for a specific period.

Or, you could restructure your source data, and put the names in one
column, with multiple rows per day. Then you could create a pivot table
with week and name in the row area, day in the column area, and another
copy of Name in the data area, as Count of Name. Not exactly what you
want, but it would give a similar snapshot of the schedule.


David Nelson wrote:
Is it possible to have a pivot table return a non-arithmetic value? What I
have done is create a table of Date, Day, Week, Month, Year, Name 1, Name 2,
Name 3, Name 4. The pivot table has the days across the top (Monday,
Tuesday, ...), with rows being "weeknum"bers (26, 27, 28), and page controls
being month and year. So what I am after is filling in the name fields with
peoples names (Mary, Joe, Steve, ...), and having them display in the days
of the week that they have scheduled to work. Is this possible?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html