Invesment Allocation Vs. Target Matrix

Hello All!
I am attempting to create a matrix that will show and compare current investment allocation and the target allocation. I don't feel like this should be too difficult but I am struggling with getting the target to sum up correctly on each level of the matrix. Any help would be appreciated. Here is an example of what I would like it to look like:

Here are some example data sets:

Please let me know if you have any questions or if I can provide anything further.

Thank you, 

Mike