I need to create a pivot table taking data from other 2 pivot tables. Is it
possible?
Appreciate suggestions.
Mukund
I need to create a pivot table taking data from other 2 pivot tables. Is it
possible?
Appreciate suggestions.
Mukund
You can create a pivot table from two or more data sources, as described
here:
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks