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???

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

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.


"Todd1" wrote in message
...
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???