one pivot table from two sources?

[cjmitton]

I'm new to pivot tables and have currently only set them up from the Wizard when I get data from my DB. This has worked fine so far but I have been set a challange from my manager to provide a pivot table which takes information from two separate data downloads.

First download has loads of entries in that I will need sub total (they are lots of financial entries) these entries are linked by two fields a customer number and a job number.
The other download is for the invoice system, we may have one or more invoice associated to the same customer and job number again I will have to sub total them.

Then in the one pivot table have the customer number, job number, sub total of the financial entries (download 1) and sub total of all invoice (download two).

I can do this without pivot tables but the want to drill down to the various entries in either download one or two to they can compare. I've tried a few google searches but they have not come up with anything relevent and maybe its my terminology that wrong (as it usually is!).

I'm using Excel 2010!

Any assistance to aim me in the right direction would be great.

 

[dhExcel]

Check out PowerPivot. That is exactly what it was made to do. After all, you are in the PowerPivot forum.

 

[powerpivotpro]

Try this example of using PowerPivot with Excel 2010 to create a pivot from multiple tables:

http://www.powerpivotpro.com/2009/11/temperature-mashup-example/

You can even download the workbook:

http://www.powerpivotpro.com/2009/11/temperature-mashup-demo-download-the-workbook/

And here's a more advanced example of Budget and Actuals:

http://www.powerpivotpro.com/2012/01/salesbudget-integrating-data-of-different-grains/

 

[cjmitton]

Thanks for that, I just saw 'pivot' and my mind did the rest!!!!

I've had a few late nights due to an issue here at the office so will look in more detail tomorrow when I've had some sleep and my brain is working.