Pivot Table Columns

[Guest]

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]

Did you try dragging the data "button" to the column field?

Debra Dalgleish shows how:
http://contextures.com/xlPivot02.html#Multiple

 

[Guest]

Drag the "Data" field in the pivot table over the "Total" cell in the top
right and release. That should pivot it the way you want.