Cascade Filtering and counting

Hello,

I have a table similar to the one on the left. I want to count the colors of each city and turn it into a table like the one on the right. The city list is not fixed, so I can’t use a fixed number of filters. I can’t be the first to encounter such a thing, but I couldn’t find it in the forum. Does anyone know an easy way to do this?