Hi,

thanks again for your reply.
Your proposed solution does indeed show only data for last year, however the data is also grouped by month, so I am getting monthly totals in the resultant pivot table. I would like to see the total for the whole year,

thanks,

Brian