Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rows to columns in a table or pivot table | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
add columns to a pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) |