Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mega Complex Pivot Table design question
Hi Everyone,
I am trying to work out f it is possible to create a pivot table with some special beahviours. We have a large source data worksheet that contains four different types of 'fact' for many products. These products are arranged row by row, and the facts are column by column. So far so easy. Making a pivot table from this is pretty straight forward. What we also need to do, and where I need the help, is to be able to have a list of products on another worksheet that acts as a definition for a group on the pivot table. When the pivot table is made it would be desired to be able to see the summary data for the group (and hide the lower level data). I am not quite sure the best way to go about this. Any help would be greatly appreciated. We are using Excel 97. Thanks in advance The Frog |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook pivot table design function | Excel Worksheet Functions | |||
Pivot Table design problems (% of grand total etc) | Excel Discussion (Misc queries) | |||
Pivot Table Design | Excel Worksheet Functions | |||
Complex Pivot Table | Excel Discussion (Misc queries) | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel |