linking to master table to match fields and summarize

[SH-VE]

I have a table (table#1) with the budgeted quantity of each item (supplemental part#) for each month. I need to use this table with a master sales table (table#2) which has other data fields for these supplemental part #.

Table #1
table 1

Below is how the final table of the report looks:

Final table in which table#1 need to be inorporated

Now, I am not able to unpivot first table as it creates many to many relationship with the master table .

Please suggest the best way to achive what I am looking for.

Thanks in advance for help.

[Greg_Deckler · Accepted solution]

I would unpivot and put in a bridge table.

[SH-VE]

It worked , Thanks for help.

[Greg_Deckler]

Great! 🙂