EXCEL07 how to use text in a PivotTable value field

C

Courtney G

I am new to pivot tables and I am learning in Excel 2007. I would like to
use pivot tables to view text (rather than figures and totals) in a variety
of ways. For example, I have created a simple, tidy excel worksheet as my
data source. All columns are non-date text values (notes about the related
rows). Let's say column one is labelled SURNAMES and subsequent columns are
labelled NOTES1, NOTES2, NOTES3, and so on. I have created a pivot table
using data from this worksheet. I want to use pivot tables to view the
SURNAMES column data next to the NOTES3, etc. column data, but when I attempt
to do this the pivot table wants to count the data rather than just showing
it. Is there a way around this?

Thanks in advance for any help you can offer.
 
R

Roger Govier

Hi Courtney

Drag Surname to Row labels
Drag Notes3 to Row Labels
Don't drag anything to the Values section
Click on the PT >Design tab>Layout section>Report Layout>Show in Outline
form
Click on the PT >Design tab>Layout section>Grand Totals>Off for Rows and
Columns
 

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

Similar Threads

The PivotTable field name is not valid (error) 1
Very basic pivottable question (XL2003) 1
How can I view comments in a pivottable? 1
How can I change the source data reference to another pivot table? 2
How do I perform extended calculations in a Pivot Table in Excel 2 4
Error on text wrap pivot table 1
Single Filter to change all Pivot Tables in a Workbook 8
Data missing in field in pivot table 1

Top