Main contributor

Hello!

I have a table consisting of three columns: Department, Product and Profit. The profit is summed up per Department.

My end goal is an analysis of the table as shown in the text to the right.

How would you tackle such a problem?

The sum per department is known, but how do I find the main contributing product (for that department's total profit?)