Problem creating clustered columns by year

[Baddeck]

It believe it should be straight forward but I can't get my data (below left) to look like this (below right). I'm just getting 1 total column by year. I'm not currently using a measure.

[Baddeck]

Thank you, that solved it.

[vicky_ · Accepted solution]

Try with the following configuration:

And you can adjust the colours under the format section of the visuals pane.