Hello All,

I'm desperately looking for the following solution:

I have two pivot table: Budget Cost(1) and Actual Cost(2). Both have Yearly data from different locations. an example

Budget Actual
Year Location1 Location 2 year location location 2
2012 2012
quarter 1 $$$ $$$ quarter 1 $$$
quarter 2 $$$ $$$ quarter 2 $$$

Data source of Pivot 1 is a daily sheet that I grouped to year and quarter. data source is already formatted to quarter and year

How can I create a new pivot or combine those two pivot, so I can make a column chart that shows the budget and actual cost?

Thank you very much.