Pivot Data as Text

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
 
R

Roger Govier

Hi Tommy

The closest you will get is to Drag Day to Row area, followed by Name to Row
Area, followed by Tool to Row Area, then drag tool again to Data area as
Count of Type
Double click on Day heading and set Subtotals to None. Do the Same for Name.
Right click on any cell in the PT >Table Options>de-select Grand Totals by
Column

What you would end up with would be

Day Name Tool Total
Mon Bob Saw 1
Joe Drill 1
Sam Lathe 1
Tue Bob Lathe 1
Joe Drill 1
Sam Saw 1
Wed Bob Saw 1
Joe Lathe 1
Sam Drill 1

You could hide the column containing Total--
Regards
Roger Govier
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top