ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table (https://www.excelbanter.com/excel-discussion-misc-queries/74062-pivot-table.html)

Muks

Pivot Table
 
I need to create a pivot table taking data from other 2 pivot tables. Is it
possible?
Appreciate suggestions.

Mukund

Debra Dalgleish

Pivot Table
 
You can create a pivot table from two or more data sources, as described
he

http://www.contextures.com/xlPivot08.html

but the results are not the same as a normal pivot table.

Also, if the pivot tables have multiple row fields, there will probably
be many blank cells in the outer fields, because headings are not
repeated on every row.

If possible, combine the source data on which the two pivot tables are
based, and create the new pivot table from that data.

Muks wrote:
I need to create a pivot table taking data from other 2 pivot tables. Is it
possible?
Appreciate suggestions.

Mukund



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 03:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com