Pivot Table: Display data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi
If I want to keep the data in the data area of pivot table, and NOT
summarize it, is there anyway to do it in Excel? I am able to get this report
in MS Access, which is slow, but not in excel. For eg. if I want to make a 12
quarter forecast of projects for my employees, I would need a report from the
following data, that is saved in a SQL server -
the data looks like this
ID Yr Mo Project
1111 2006 1 A
1111 2006 2 B

and so, I want to generate a pivot table report that looks like this -

ID Yr
1 2 3 4 5 .....
1111 A B A C D
1112 C D A B D .....

So in this report, I would like to see the project names, and not
necessarily the sum or count, etc.

Thank you
 
In a pivot table, you can't show text in the data area, as you can in an
Access crosstab report. You can add the fields to the row area, where
the text will be visible, then add fields to the data area, to show the
count of the row field items.
 
Back
Top