one pivot table from two sources?

cjmitton

Board Regular
Joined
Sep 17, 2008
Messages
65
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.
 
Last edited:

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

dhExcel

New Member
Joined
Jan 30, 2012
Messages
32
Check out PowerPivot. That is exactly what it was made to do. After all, you are in the PowerPivot forum. :eek:
 

powerpivotpro

Board Regular
Joined
Jan 18, 2012
Messages
242

cjmitton

Board Regular
Joined
Sep 17, 2008
Messages
65
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,741
Messages
5,524,560
Members
409,584
Latest member
Devil_717

This Week's Hot Topics

Top