Pivot Table -- Text?

A

ARBrock

I don't think this is possible, but thought I'd check to be sure.

Can a pivot table display text values or must a pivot table do calculations
and only display numbers??

I am basically trying to create a report from data I pulled from MS
Project... I've got a resource name, a list of dates, and a list of projects.
I'm looking for a solution to the cross tab report "who does what when."

I want to create a pivot table that will display the dates as columns, and
the resource names as rows... and then in the data section the project name.
I want it to look something like this:

Date Date Date Date
Resource Project 1 Project2 Project3 Project4
Resource Project 2 Project2 Project3 Project1
Resource Project 1 Project2 Project3 Project4


I dont want a count or a sum... just the name of the project. Can this be
done with a pivot table?

-AR
 
D

Debra Dalgleish

No, you can't show the values from text fields in the pivot table's data
area. If you number the projects, you could display those numbers,
instead of the names.
If you have Microsoft Access, you could create a crosstab query, and use
the First or Last summary function to display the text.
 

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