Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable - summing more than one data field
Hi, this may be a stupid question, but I can't figure it out! I have data in
the following format: Product Price Quantity Revenue Client 1 X 1 2 2 Client 1 Y 5 7 35 Client 1 X 1 10 10 Client 2 X 1 3 3 I would like to create a pivot table that shows both the total quantity and revenue by client by product. I can easily make the table for either quantity or revenue, but am not sure how to show the sums for two data fields at the same time. Example: Quantity Revenue Client 1 Product X 12 12 Product Y 7 35 Client 2 3 3 Can you tell me how to do this? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable - summing more than one data field
First label the column with client 1. then create your pivot table with the
range you need (example A1:E5), tell the wizard where you want it created. then click on the layout button and click and drag cliet column to the ROW field, Product to the COLUMN field. Then click and drag quantity and Revenue to the data area. If they do not show Sum of Quantity and Sum of Revenue then double click each one and select Sum. Then if you do not want to see each row and column totals then click on the options button and check or uncheck the appropriate boxes. Then click finish and the table will appear as shown below. Product Client Data x y client 1 Sum of Quantity 12 7 Sum of Revenue 12 35 Client 2 Sum of Quantity 3 Sum of Revenue 3 "Kruti" wrote: Hi, this may be a stupid question, but I can't figure it out! I have data in the following format: Product Price Quantity Revenue Client 1 X 1 2 2 Client 1 Y 5 7 35 Client 1 X 1 10 10 Client 2 X 1 3 3 I would like to create a pivot table that shows both the total quantity and revenue by client by product. I can easily make the table for either quantity or revenue, but am not sure how to show the sums for two data fields at the same time. Example: Quantity Revenue Client 1 Product X 12 12 Product Y 7 35 Client 2 3 3 Can you tell me how to do this? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable - summing more than one data field
Thanks. Is is possible to have the "Sum of Quantity" and "Sum of Revenue" as
columns instead of rows? "SSG QuarterMaster" wrote: First label the column with client 1. then create your pivot table with the range you need (example A1:E5), tell the wizard where you want it created. then click on the layout button and click and drag cliet column to the ROW field, Product to the COLUMN field. Then click and drag quantity and Revenue to the data area. If they do not show Sum of Quantity and Sum of Revenue then double click each one and select Sum. Then if you do not want to see each row and column totals then click on the options button and check or uncheck the appropriate boxes. Then click finish and the table will appear as shown below. Product Client Data x y client 1 Sum of Quantity 12 7 Sum of Revenue 12 35 Client 2 Sum of Quantity 3 Sum of Revenue 3 "Kruti" wrote: Hi, this may be a stupid question, but I can't figure it out! I have data in the following format: Product Price Quantity Revenue Client 1 X 1 2 2 Client 1 Y 5 7 35 Client 1 X 1 10 10 Client 2 X 1 3 3 I would like to create a pivot table that shows both the total quantity and revenue by client by product. I can easily make the table for either quantity or revenue, but am not sure how to show the sums for two data fields at the same time. Example: Quantity Revenue Client 1 Product X 12 12 Product Y 7 35 Client 2 3 3 Can you tell me how to do this? Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable - summing more than one data field
Drag the Data field button onto the cell that contains the word "Total",
as shown he http://www.contextures.com/xlPivot02.html Kruti wrote: Thanks. Is is possible to have the "Sum of Quantity" and "Sum of Revenue" as columns instead of rows? "SSG QuarterMaster" wrote: First label the column with client 1. then create your pivot table with the range you need (example A1:E5), tell the wizard where you want it created. then click on the layout button and click and drag cliet column to the ROW field, Product to the COLUMN field. Then click and drag quantity and Revenue to the data area. If they do not show Sum of Quantity and Sum of Revenue then double click each one and select Sum. Then if you do not want to see each row and column totals then click on the options button and check or uncheck the appropriate boxes. Then click finish and the table will appear as shown below. Product Client Data x y client 1 Sum of Quantity 12 7 Sum of Revenue 12 35 Client 2 Sum of Quantity 3 Sum of Revenue 3 "Kruti" wrote: Hi, this may be a stupid question, but I can't figure it out! I have data in the following format: Product Price Quantity Revenue Client 1 X 1 2 2 Client 1 Y 5 7 35 Client 1 X 1 10 10 Client 2 X 1 3 3 I would like to create a pivot table that shows both the total quantity and revenue by client by product. I can easily make the table for either quantity or revenue, but am not sure how to show the sums for two data fields at the same time. Example: Quantity Revenue Client 1 Product X 12 12 Product Y 7 35 Client 2 3 3 Can you tell me how to do this? Thanks! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable - summing more than one data field
Perfect, thank you!!
"Debra Dalgleish" wrote: Drag the Data field button onto the cell that contains the word "Total", as shown he http://www.contextures.com/xlPivot02.html Kruti wrote: Thanks. Is is possible to have the "Sum of Quantity" and "Sum of Revenue" as columns instead of rows? "SSG QuarterMaster" wrote: First label the column with client 1. then create your pivot table with the range you need (example A1:E5), tell the wizard where you want it created. then click on the layout button and click and drag cliet column to the ROW field, Product to the COLUMN field. Then click and drag quantity and Revenue to the data area. If they do not show Sum of Quantity and Sum of Revenue then double click each one and select Sum. Then if you do not want to see each row and column totals then click on the options button and check or uncheck the appropriate boxes. Then click finish and the table will appear as shown below. Product Client Data x y client 1 Sum of Quantity 12 7 Sum of Revenue 12 35 Client 2 Sum of Quantity 3 Sum of Revenue 3 "Kruti" wrote: Hi, this may be a stupid question, but I can't figure it out! I have data in the following format: Product Price Quantity Revenue Client 1 X 1 2 2 Client 1 Y 5 7 35 Client 1 X 1 10 10 Client 2 X 1 3 3 I would like to create a pivot table that shows both the total quantity and revenue by client by product. I can easily make the table for either quantity or revenue, but am not sure how to show the sums for two data fields at the same time. Example: Quantity Revenue Client 1 Product X 12 12 Product Y 7 35 Client 2 3 3 Can you tell me how to do this? Thanks! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summing columns if there is data | Excel Worksheet Functions | |||
Pivottable adding calculated field? | Charts and Charting in Excel | |||
ranking query | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) |