How to display different categories and their totals in a table

I have a card that contains a large table.

The table is made up of six different categories or groupings of data, and I am having trouble displaying it all in a simple and clean manner.

Here are the guidlines:

  • I need to display a percentage score for each category that is calculated based on the category totals.
  • I also need to show a final percentage score that is based off ALL the data (not just a single category).
  • It should be clear to the user how each of these scores is calculated.

If I didn't need to show the category scores and category totals I could just put it into one big table broken up by section headings for each category, but that does not work once I start including the category score calculations.

Below is a quick mock-up of what I have so far. It's just an example, the values do not add up correctly, but it illustrates what I am dealing with.

Also I cropped out some of the rows and categories to make it a smaller sized image. The real table has 6 categories plus about twice as many rows.

enter image description here