Joint Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone help, I have 2 sets of data and I prepared 2 Pivot Tables. Is
there any way I can join thest 2 Pivot Tables and form 1 Pivot Table (but not
joining 2 sets of data together). Thank you.
 
Not easily no. You can always use the 'Multiple consolidation ranges'
option to choose both sets of data as your source, but you probably won't
like the result.

Is there any reason you cant just create a third combined table if you don't
want to touch the other two, and then use that as the source data for the
Pivot Table

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Pivot table 1
Pivot Table Help! 1
Pivot table report invalid 0
Pivot using 250,000 rows of data in Excel? 1
Consolidate Pivot Tables/Cache using Excel 2003 1
pivot table loosing decimals (vba) 1
Turning Data into a Table 1
Excel VBA For excel 0

Back
Top