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??? |
Pivot Table Columns
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 |
Pivot Table Columns
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??? |
All times are GMT +1. The time now is 07:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com