I want to create a report (table) with account names on the left and multi-select values as columns with a total at the bottom. How can I do this?

For example, if the multi-select field in each account is a list of paint colours, I’d like to create a table that looks like this. The objective is to see the total demand for each paint colour.