Creating multiple columns from the same data in a Pivot Table

Question

I am new to Pivot Tables and learning as I go.  I have created a pivot table that averages 3 data fields by city, something like this:

CITY	A	B	C
ARKOMA	1.78
ARMA	2.45		2.35
AUBURN	0.64
AUGUSTA	5.37		3.13
BARLING	7.50
BELLA VISTA	5.02	2.52	0.75

but I would like to add a coulumn for each range that displays a count for the same data:

CITY	Count A	Avg A	Count B	Avg B	Count C	Avg C
ARKOMA	5	1.78
ARMA	7	2.45			6	2.35
AUBURN	2	0.64
AUGUSTA	10	5.37			5	3.13
BARLING	3	7.50
BELLA VISTA	2	5.02	1	2.52	2	0.75

I can't figure out how to make multiple columns for the same information, one counting and one averaging.  Can this be done?

Answer 1

Just drag "A", "B" and "C" to the Values field area again - it will show "Count of A2", "Count of "B2", etc.  Then you can change the second ones to "Sum of..."

HTH,

Eric

Answer 2

Perfect.  Thanks for the help.