Upon researching solutions I became aware of the option when adding a group to use Adjacent Below...
This allowed me to keep my state grouping, and create a new group on company and each individual metric without having to create a new matrix for each metric. This will ultimately lead to the expected output. Here is a screenshot of the new test table that produced results similar to the expected output. Note, I say similar because I left off the total field in this test.