![]() |
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? |
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 |
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 |
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 |
All times are GMT +1. The time now is 02:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com