Did you try dragging the data "button" to the column field?
Debra Dalgleish shows how:
http://contextures.com/xlPivot02.html#Multiple
Todd1 wrote:
I need help with getting the proper columns in a pivot table.
To simplify things, I have this type of data
Todd 300
Todd 100
Todd 200
Chris 500
Chris 75
Chris 250
Chris 100
I know how to show a pivot table with the total Sum and the Total Count. It
displays the count and sum like this:
Todd 3
600
Chris 4
825
I need it to display the count and sum in columns so it's all on the same
row like this:
Todd 3 600
Chris 4 825
I've tried every combination of placing fields in the page, column, rows and
Data part of the table. Any suggestions???
--
Dave Peterson