I'm not entirely clear on your dataset and the necessary Tableau Rows/Cols layout, but one thing you can do is duplicate the measure or dimension, allowing multiple names for the same thing. ...
If this doesn't work, perhaps you could post a Tableau example (save it as a packaged workbook twbx), and I'm sure someone can help.
Here's one relatively simple solution that involves creating two worksheets and combining them in a dashboard:
Currently your "Total" is an alias for null SDG values. I created two new calculated fields
SDG --- total alias 1 = IF ISNULL([SDG]) THEN "Total 1" ELSE [SDG] END
and duplicate, replacing 1 with 2
SDG --- total alias 2 = IF ISNULL([SDG]) THEN "Total 2" ELSE [SDG] END
Then I duplicated your Sheet 1 twice, replaced the SDG field and removed one of the Ct_Pay measures, for Total 1--Ct_Pay and Total 2==Ct_Pay_tot, respectively.
Last I created a new dashbard with both of these worksheets, hiding the duplicate row headers on the second sheet.
The disadvantage to this approach is that filtering / selecting headers in the view is a bit more difficult, since the action needs to be applied to both sheets.
See attached twbx. I'm not sure if you want the total in the first column (like your Tableau example) or the last column (like your Excel example), but you can change this by dragging it or selecting the pill and specifying a sort order.
report1_jimw.twbx.zip 58.7 KB