But I don't want a total column on the right hand side - I don't care about seeing the sum of the 5 years, and there doesn't seem to be any way of getting rid of the far right column.

Even your example has the right hand column adding up the prior years.

Unless you are doing a year to date, adding the totals are unnecessary; 5 years of total are unnecessary unless specific to a sale of a business or something unusual.

Change this!