Merge PivotTables

[goss]

Hi all,

Using Office 2013.

I have 3 separate PivotTables from 3 separate databases though they share some elements in common such as customers and dates
Is it possible to now merge the 3 PivotTable so I can see Rolling Forecast, Budget, and Actual one above the other for each customer?

For example

Boeing..Forecast...9.2M
Boeing..Budget....9.5M
Boening..Actual...8.9M

thx
w

[noboffinme]

Hi goss,

Yes, there is a consolidated Pivot Table option if you have a common field in all tables.

Have a look at this You Tube video.

http://www.youtube.com/watch?v=hTw-3PbYuKY