Calculation using dynamic table (Spending many many hours on this and could not figure it out! )

(First of all, sorry for the long context ) I have created the dynamic matrix table (Table1) below for two of the subsidary companies called Apple1 and Apple2. When I select the silcer value, the number changes accordingly. Basically, Apple1 and Apple2 both have similar tool and each tool are used in multiple locations. I created this Matrix table below that summarized the average utilization for each week at each Tool_Location. Column O is the average utilization for the most recent three weeks. My question is, how many Tool_locations are over 90% utilization for the most recent three months per Tool Family. And what is the percentage per Tool Family. Basically, the logic is like (Take A Tool Family as example): Count(Column O>90%)/COUNTIF(Tool_Location, Tool Family="A") = 5/8 =62.5%. The final table looks something like Table 2. The tricky part is that the matrix table is dynamic based on companies, and the last 3 weeks average utilization per Tool_location is also dynamic when week changes. Please let me know if you have any thoughts on this. Much appreciated in advance.