Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I pivot multiple data fields and display them in a column?
I have a table with multiple records for each Order ID. I want to create a
pivot table to sum 4 different fields for each unique ID, as well as display other fields, such as dates, which do not need to be added. When I use the layout feature in Excel 2003, I can do this but all the summed fields are listed one below the other to the right of the other (not summed) fields. What I want is to be able to recreate a table with one record for each unique ID with the summed fields displayed in separate columns. I hope this is clear. Any help would be appreciated. Marc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I pivot multiple data fields and display them in a column?
After you add the fields to the pivot table's data area, drag the Data
button onto the cell that contains the word Total. There's a picture he http://www.contextures.com/xlPivot02.html Marc Forget wrote: I have a table with multiple records for each Order ID. I want to create a pivot table to sum 4 different fields for each unique ID, as well as display other fields, such as dates, which do not need to be added. When I use the layout feature in Excel 2003, I can do this but all the summed fields are listed one below the other to the right of the other (not summed) fields. What I want is to be able to recreate a table with one record for each unique ID with the summed fields displayed in separate columns. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I pivot multiple data fields and display them in a column?
Thank you very much.
"Debra Dalgleish" wrote: After you add the fields to the pivot table's data area, drag the Data button onto the cell that contains the word Total. There's a picture he http://www.contextures.com/xlPivot02.html Marc Forget wrote: I have a table with multiple records for each Order ID. I want to create a pivot table to sum 4 different fields for each unique ID, as well as display other fields, such as dates, which do not need to be added. When I use the layout feature in Excel 2003, I can do this but all the summed fields are listed one below the other to the right of the other (not summed) fields. What I want is to be able to recreate a table with one record for each unique ID with the summed fields displayed in separate columns. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
Display the source for a pivot table page field | Excel Worksheet Functions | |||
Display data from multiple worksheets' cells in one worksheet | Excel Worksheet Functions | |||
How to display repeating data in Pivot Tab | Excel Discussion (Misc queries) | |||
How to have multiple columns in pivot table data area? | Excel Worksheet Functions |