Count all occurrences of two string columns for cross table view

Hello everyone,

I have the following problem that I simply cannot solve:

| Country | Content type |
| USA     | News         |
| Canada  | Blog         |
| China   | News         |
| Canada  | News         |
| USA     | Blog         |
| USA     | Images       |

I want to display the number of occurrences for the two columns in a crosstab like as follows:

|        | News | Blog | Images |
| USA    | 1    | 1    | 1      |
| Canada | 1    | 1    | 0      |
| China  | 1    | 0    | 0      |

(E. g. 20 entries for USA with content type = Blog)

I tried unique concat with count, group by, column aggregation but I seem to miss something as I’m not able to get both columns counted.

Thanks!