How to sum multiple rows from another table

I'm not sure what you are asking, but the better way to shape your data is to load a table that looks like this

Subsidiary, Category, Year, Sales

with a table structured like this, it is easy to build summary matrix visual by dragging columns

Subsidiary, Category, to the rows of the matrix

Year, to the column

Sales to the values