You should be able to drag a second copy of the field from the field
list to the pivot table's data area. Make sure that the pointer is over
the data area when you drop the field.

wrote:
I'm new to pivot tables.

I wanted to have one pivot table column that counts the entries in a
data column AND another pivot table column that sums the values of the
same data column. Excel doesn't seem to let me put more than one copy
of the column into the data section of the table. I can change it
between count and sum, but i want to show both at the same time.

Any ideas?

Thanks.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html