Count and Sum data in same Pivot table
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.
|