Pivot table: displaying text instead of number; can it
 

okay, this is what I'm trying to do.

In the column I have Job Position, Row I have dates and in the data I want
Employee's name. So I'll end up with a table that will show every day who
was in what position. Does the data have to be a number, can it be text?

Pivot table: displaying text instead of number; can it
 

The stuff in the data area is limited to numeric summaries--count, average, sum,
....

The stuff in the page, row, column area can be text, though.

Allen wrote:

okay, this is what I'm trying to do.

In the column I have Job Position, Row I have dates and in the data I want
Employee's name. So I'll end up with a table that will show every day who
was in what position. Does the data have to be a number, can it be text?

--

Dave Peterson

Pivot table: displaying text instead of number; can it
 

Sorry to hear that

Thanks
"Dave Peterson" wrote:

The stuff in the data area is limited to numeric summaries--count, average, sum,
....

The stuff in the page, row, column area can be text, though.

Allen wrote:

okay, this is what I'm trying to do.

In the column I have Job Position, Row I have dates and in the data I want
Employee's name. So I'll end up with a table that will show every day who
was in what position. Does the data have to be a number, can it be text?

--

Dave Peterson