Matrix Table - Subtotal VS Grand Total Issue!

I have created a matrix table with 3 fields under row, 1 field under columns and then values.  I am trying to achieve the look of the tabular format from excel in this matrix.  I have removed the stepped layout and trying to just have the grand total at the bottom calculating for each of the columns BUT in order to have that I have to have the individual subtotals on.  I created a hierarchy group for the fields under my rows and it works if I only have 2 fields but as soon as I add a third field it adds the subtotals back in.  Is there any workaround?  I have been trying to figure this out and I am stuck.

I want to maintain each of the fields under rows in that tabular format or having their own individual colulmn while ONLY subtotaling the year columns.  Any help is greatly appreciated

matrix table with visible grand totals with my formatting selections to the righttable showing the fields for rows (including the created hierarchy containing 2 fields), columns and valuesAdded a 3rd field to the hierarchy and individual row totals are visable