Thanks,

I have just changed the group by clause to use:

year(sh.orderdate) rather than using the alias created in teh select statement and this has resolved the problem.

Thanks for your reply.