View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Todd1 Todd1 is offline
external usenet poster
 
Posts: 6
Default Pivot Table Columns

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