Reporting using text mode to add a total column to show the sum of all rows!

I think the easiest and most thorough way would be a matrix report.

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/create-manage-reports/create-matrix-report.html?lang=en

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/mysocalledideas