Help with pivot table to merge data from an ODBC table, a manual entrie table and a summary pivot table of them

[Midas1]

Hi,

I have the following:

• A table from ODBC with product code, supplier code, supplier name, current inventory and monthly sales
• A table where I do manual adjustment. Product code, monthly adjustments
• Summary pivot table with all the information from ODBC table plus columns of merging the monthly sales + adjustments.

ODBC table exemple:
Product code | Supplier Code | Supplier Name | Current inventory | Month1 | Month2 | Month3....Month12
1222 | 370 | supplierxzy | 2000 | -150 | -200 | -125...
1275 | 420 | supplierabc | 1000 | -150 | -200 | -125...

Manual adjustment table exemple:
Product code | Month1 | Month2 | Month3....Month12
1222 | 50 | -25 | 100...
1222 | 20 | 50 | -20...
1275 | 30 | 45 | 100...
1275 | 100 | 45 | -50...
There is more than 1 line per product adjustment!

Summary Pivot table exemple desired output (current inventory + sales + adjustments):
Product code | Month1 | Month2 | Month3....Month12
1222 | 370 | supplierxzy | 1920 | 1745 | 1700...
1275 | 420 | supplierabc | 980 | 870 | 795...
...
Please note for month1 is current inventory + sales of month1 + adjustments of month1
Month2 is sum of month1 + sales of month2 + adjustment of month2
Month 3....

Any idea how I could acheive this? I tried but it look like I cannot sum the value from manual adjustment because it turn into "distincs values" and the calculated field is greyed out.

I dont have power pivot... so it is either pivot table or a lot of vlookup...

Thanks!