| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create pivot table with master/detail data from 2 worksheets
I am trying to create a report that combines master datat (Sales
Opportunities) with detailed history showing the date when various tasks related to the Opportunities were completed. The data comes in two separate exports to two worksheets - joined by a common id field. Any suggestions. I tried the Consolidate process to create a cross tab but I don't want any of the consolidate "summary functions" like sum or avg. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table - New Data | Excel Discussion (Misc queries) | |||
| pivot table | Excel Discussion (Misc queries) | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
| Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
| Need Formula to display pivot table source data | Excel Worksheet Functions | |||
Linear Mode
