Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables-2 Questions
Question # 1
I have a pivot table that's laid out similar to below. Cell 1 | Cell 2 -------------------------------------------------|-------------------------------------- Part # Prod A Prod B Prod C Prod D | Prod A Prod B Prod C Prod D 123 3 1 | 3 1 456 4 1 | 2 789 5 | 4 ---------------------------------------------------------------------------------------- I would like it to look like the chart below. Only showing the products that are being produced in that specific Cell automatically when the pivot is created. Cell 1 Cell 2 Part # Prod A Prod B Prod C Prod D 123 3 1 3 1 456 4 1 2 789 5 4 Question #2 How can you set the pivot table to automatically add a data column once it's entered into the main data area without having to go into layout and manually adding??? eg. add part # for product E and have it appear in the Cell 2 section Thanks in advance for any help... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
Problems with updating category names in pivot tables | Excel Discussion (Misc queries) | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) |