LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Pivot Table -- Text?

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pivot table converts to text Markish Excel Discussion (Misc queries) 2 June 19th 07 04:19 PM
Pivot Table and Text James O Excel Discussion (Misc queries) 1 September 26th 06 06:29 PM
text in a pivot table Cate Excel Discussion (Misc queries) 1 June 15th 06 11:53 PM
Pivot Table with Text David Nelson Excel Discussion (Misc queries) 2 May 20th 05 07:24 PM
pivot table with text Neil Excel Discussion (Misc queries) 2 February 22nd 05 10:19 PM


All times are GMT +1. The time now is 08:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"