Joint Pivot Table

T

Tony

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.
 
K

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 
Top