Subject: How to Display Department-Wise Totals in a Single Row in Tableau

Hi Tableau Community,🙏

I have a Tableau worksheet that shows the marketing department's contributions broken down by department. I need to find a way to display the total contribution for each department in a separate column within the same row.

For reference, I have attached the calculation sheet that illustrates the data structure.

Could anyone guide me on how to achieve this in Tableau?

Thank you!🙌