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
Thank you for your help!!