Pivots Question

Raziel2807

New Member
Joined
Jul 24, 2008
Messages
2
Hello people.

I have two pivots on excel that they are updated often, they have the same templates, but different data.

I need to create a third pivot based on the information shown on these two.

How can I get it? :confused:
I do not have te data that generated the pivot. :(
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi & Welcome to the Board!

If you don't have the underlying data then you will be limited to what information you have within your current pivot tables.
 

Raziel2807

New Member
Joined
Jul 24, 2008
Messages
2
Hi & Welcome to the Board!

If you don't have the underlying data then you will be limited to what information you have within your current pivot tables.

Ok, but how can I build another pivot based on the information of these two?
I need a summary of these two.
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Since pivots already contain summarised data (and don't always present it in a useful format) I would use formulas to summarise the two. How you do this depends on how you want to summarise the data (ie what results you want to display). You haven't provided any sample data, so it is difficult to advise.
 

gapa

New Member
Joined
Jul 3, 2007
Messages
10
If the pivot is using the same template, why not just combine the data together ? Maybe have an additional column to id the different set of data.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,509
Messages
5,596,566
Members
414,078
Latest member
Frills

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top