T
tommcbrny
Hello,
Is it possible to display information in the "Data" area of a pivot table as
the actual data text instead of a numeric count, sum, average, etc?
I have data that contains a days, names, and positions. I would like to
show the day on the left as rows, the names and columns across the top, and
the position in the data portion, something like this:
Joe Sam Bob
Mon Lathe Drill Saw
Tue Drill Saw Lathe
Wed Lathe Saw Drill
Currently, I am only able to achieve something close as follows:
Joe Sam Bob
Mon Lathe 1
Drill 1
Saw 1
Tue Lathe 1
Drill 1
Saw 1
Is there any way to get the text data instead of numeric in to the data
portion of the pivot?
Thank you
Tom
Is it possible to display information in the "Data" area of a pivot table as
the actual data text instead of a numeric count, sum, average, etc?
I have data that contains a days, names, and positions. I would like to
show the day on the left as rows, the names and columns across the top, and
the position in the data portion, something like this:
Joe Sam Bob
Mon Lathe Drill Saw
Tue Drill Saw Lathe
Wed Lathe Saw Drill
Currently, I am only able to achieve something close as follows:
Joe Sam Bob
Mon Lathe 1
Drill 1
Saw 1
Tue Lathe 1
Drill 1
Saw 1
Is there any way to get the text data instead of numeric in to the data
portion of the pivot?
Thank you
Tom