| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with pivot tables
I would like to know if it is possible to take the results from more than one
pivot table and combine those results to create a report with all the info on it. How would this be done? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help with pivot tables
You can use a GetPivotData formula to extract the data from different
pivot tables. There are examples in Excel's Help, and he http://www.contextures.com/xlPivot06.html cindy wrote: I would like to know if it is possible to take the results from more than one pivot table and combine those results to create a report with all the info on it. How would this be done? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help with pivot tables
Hello, I went to the www.contextures.com but I did not see clear instructions
on how to combine more than one Pivot table. Could you explain how? Thank you. "Debra Dalgleish" wrote: You can use a GetPivotData formula to extract the data from different pivot tables. There are examples in Excel's Help, and he http://www.contextures.com/xlPivot06.html cindy wrote: I would like to know if it is possible to take the results from more than one pivot table and combine those results to create a report with all the info on it. How would this be done? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help with pivot tables
Hi MayJuneJul
See if the article at http://www.contextures.com/xlPivot08.html does what you want. Regards, Pedro J. Hello, I went to the www.contextures.com but I did not see clear instructions on how to combine more than one Pivot table. Could you explain how? Thank you. "Debra Dalgleish" wrote: You can use a GetPivotData formula to extract the data from different pivot tables. There are examples in Excel's Help, and he http://www.contextures.com/xlPivot06.html cindy wrote: I would like to know if it is possible to take the results from more than one pivot table and combine those results to create a report with all the info on it. How would this be done? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
| When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
| Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
| Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Linear Mode
