Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problem with pivot table
I am trying to create a pivot table. I have the following fields: cust#,
item#, and quantities for different months. I want the pivot table to look like this: data cust item jan feb march 123 1 1 2 3 123 2 4 5 6 124 1 1 1 1 etc But I am getting cust item Data 123 1 sum of January 1 sum of February 2 sum of March 3 123 2 sum of Jan etc How do I do this? Thanks! |
#2
|
|||
|
|||
In the Pivot table, drag the Data field button onto the cell that
contains the word Total. There's a picture he http://www.contextures.com/xlPivot02.html 85225 wrote: I am trying to create a pivot table. I have the following fields: cust#, item#, and quantities for different months. I want the pivot table to look like this: data cust item jan feb march 123 1 1 2 3 123 2 4 5 6 124 1 1 1 1 etc But I am getting cust item Data 123 1 sum of January 1 sum of February 2 sum of March 3 123 2 sum of Jan etc How do I do this? Thanks! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Thank you,
It worked. "Debra Dalgleish" wrote: In the Pivot table, drag the Data field button onto the cell that contains the word Total. There's a picture he http://www.contextures.com/xlPivot02.html 85225 wrote: I am trying to create a pivot table. I have the following fields: cust#, item#, and quantities for different months. I want the pivot table to look like this: data cust item jan feb march 123 1 1 2 3 123 2 4 5 6 124 1 1 1 1 etc But I am getting cust item Data 123 1 sum of January 1 sum of February 2 sum of March 3 123 2 sum of Jan etc How do I do this? Thanks! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
I am having trouble keeping numbers formatted in a Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Pivot Table Problem | Excel Worksheet Functions |