Reporting from 2 tables and using relationships

Good Morning, I am working on a file to report cycle times for work processes. I also need to account for any downtime between those cycles and list the reasoning why. The attached file shows what I have so far. Sheet 1 is my data entry and on Week_MonthS I have the other table in AM:AN to create the relationship. The issue I am having is in sheet Chamber1. I have an example of what I want the pivot table to do below on Line 22. Is there a way to do this?

There is no relationships, so you need to create them

one way you can do is merge two tables and create PivotTable from merged table

Sheet: Source
Sheet: Pivot

When I tried making a relationship earlier it told me the type was a mismatch. I tried to build a relationship between the reason and the down time between the tables.

So would I just insert the Week/Reason into the bottom of the table for each chamber?

Noooo

You've Ex2013/2016 so probably there is PowerQuery (2013) or Get&Transform (2016). Add first and second table to Workbook Queries then Merge these two into one. Then create PivotTable from merged table.
To see it in my example: Data - Show queries

My example has nothing common with your data except values

Okay, so I was able to get PowerQuery onto my office computer. I have the connections made but the information is being repeated for each week on the pivot table, any help and explanations on what I did wrong with the connections would be fantastic!

Probably you merged queries by Week not by Reason/Reasoning
try select in 1st query : Reason, in the 2nd query : Resoning, Join kind : as is

you can't merge queries by columns with different kind of data or you'll get any result which will not be correct
With my last attached file is that what you want ?

Here is the file with how the data should be and is represented now. I am not sure if it helped sorting the rows or not, but it works.