ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   help with pivot tables (https://www.excelbanter.com/excel-worksheet-functions/159619-help-pivot-tables.html)

CINDY

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?

Debra Dalgleish

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


MayJuneJuly

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



Infinitogool

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