Perform a Count of each matrix subitem where it meets a criteria within another table

[OrionTL]

I have a matrix breaking down the categories of vehicle types and their subitem when "Expanded" based on TableA. I have a value column showing how many of those particular vehicle is on order based on the sum of TableB with all the order details. Both tables have a relationship based on a single unique column tying their Category-Subitem types. I'm trying to get the count of "how many orders were fulfilled" as shown on the last column of the picture of the table below 

TableA:

TableB:

Needed Output:

Thank you for your help!!

[v-jianboli-msft · Accepted solution]

Hi @OrionTL ,

You can achieve this directly by using the data of TableB:

Output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.