| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table not cooperating
I have a pivot table created from a large spreadsheet that has a customers
entire inventory. I cannot get the available inventory to just show the total for that location when I put it in the data area of the pivot table. It always wants to do count or sum, but when it does these it changes the totals in the location. I cannot figure out how to correct this. Any ideas? Thank you... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table not cooperating
Can you give an example for one customer?
What's in the inventory table for that customer, and what would you like to see in the pivot table? What is the pivot table showing now? Jim wrote: I have a pivot table created from a large spreadsheet that has a customers entire inventory. I cannot get the available inventory to just show the total for that location when I put it in the data area of the pivot table. It always wants to do count or sum, but when it does these it changes the totals in the location. I cannot figure out how to correct this. Any ideas? Thank you... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table not cooperating
My spreadsheet looks similar to as follows with about 5000 more lines
Item Location on hand hold pending available 12345 1010011A 300 100 100 100 The pivot table I'm trying to create would have similar information but because some items have duplicate locations and all due to different inbound dates, I am trying to clean it up and make it easier for the customer to see. Basically on the page menu of the table I want to choose what Item I am looking for and it would pull up location in the row part of the pivot table. Then it would have the rest of the information in the data area On hand hold pending available 300 100 100 100 Am I describ "Debra Dalgleish" wrote: Can you give an example for one customer? What's in the inventory table for that customer, and what would you like to see in the pivot table? What is the pivot table showing now? Jim wrote: I have a pivot table created from a large spreadsheet that has a customers entire inventory. I cannot get the available inventory to just show the total for that location when I put it in the data area of the pivot table. It always wants to do count or sum, but when it does these it changes the totals in the location. I cannot figure out how to correct this. Any ideas? Thank you... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table not cooperating
I apologize for not lining those up correctly. I also for got to mention that
when I put the information in the data part of the pivot table it changes the information I want to display from the table. If I choose available it uses the sum funtion and that throws off the accuracy of what I am trying to display. Given example below, If there were supposed 3 of those lines it would show 300 in the available in each location for that item in the pivot table even though I only had 100 in each location for my spreadsheet. "Jim" wrote: My spreadsheet looks similar to as follows with about 5000 more lines Item Location on hand hold pending available 12345 1010011A 300 100 100 100 The pivot table I'm trying to create would have similar information but because some items have duplicate locations and all due to different inbound dates, I am trying to clean it up and make it easier for the customer to see. Basically on the page menu of the table I want to choose what Item I am looking for and it would pull up location in the row part of the pivot table. Then it would have the rest of the information in the data area On hand hold pending available 300 100 100 100 Am I describ "Debra Dalgleish" wrote: Can you give an example for one customer? What's in the inventory table for that customer, and what would you like to see in the pivot table? What is the pivot table showing now? Jim wrote: I have a pivot table created from a large spreadsheet that has a customers entire inventory. I cannot get the available inventory to just show the total for that location when I put it in the data area of the pivot table. It always wants to do count or sum, but when it does these it changes the totals in the location. I cannot figure out how to correct this. Any ideas? Thank you... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table not cooperating
If you change the summary function to Max, does it give you the result
that you want? Jim wrote: I apologize for not lining those up correctly. I also for got to mention that when I put the information in the data part of the pivot table it changes the information I want to display from the table. If I choose available it uses the sum funtion and that throws off the accuracy of what I am trying to display. Given example below, If there were supposed 3 of those lines it would show 300 in the available in each location for that item in the pivot table even though I only had 100 in each location for my spreadsheet. "Jim" wrote: My spreadsheet looks similar to as follows with about 5000 more lines Item Location on hand hold pending available 12345 1010011A 300 100 100 100 The pivot table I'm trying to create would have similar information but because some items have duplicate locations and all due to different inbound dates, I am trying to clean it up and make it easier for the customer to see. Basically on the page menu of the table I want to choose what Item I am looking for and it would pull up location in the row part of the pivot table. Then it would have the rest of the information in the data area On hand hold pending available 300 100 100 100 Am I describ "Debra Dalgleish" wrote: Can you give an example for one customer? What's in the inventory table for that customer, and what would you like to see in the pivot table? What is the pivot table showing now? Jim wrote: I have a pivot table created from a large spreadsheet that has a customers entire inventory. I cannot get the available inventory to just show the total for that location when I put it in the data area of the pivot table. It always wants to do count or sum, but when it does these it changes the totals in the location. I cannot figure out how to correct this. Any ideas? Thank you... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot Table Chart - With Pivot Table Totals | Charts and Charting in Excel | |||
| Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) | |||
| pivot table: create worksheetsheet using pivot table | Excel Discussion (Misc queries) | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Linear Mode
