Pivots Question

[Raziel2807]

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?
I do not have te data that generated the pivot.

 

[Richard Schollar]

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]

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]

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]

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.