Hi,

Like you, I am new to Pivot Table. After reading your post and Debra's, I explored a bit.

As you know, there are two ways we can define the rows and columns.

(1) Directly on the new table (skeleton).
(2) Via the Layout button.

If I go by (1) above, I can only have one column.

If I go by (2) above, I can drag the same data field twice. In other words, I can have sum and count in the same table.

The layout button can be found via step 3 of the wizard.

I don't like the layout right now. I don't have two columns and instead I have sum and count stack up. But I do have the info. I'll do more exploration and see if I can make two columns.

Will stay tuned and see if more guidance available.

Epinn

wrote in message s.com...
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.