Thanks for getting back to me.
I need to use 'the hardway' you mention above so that I can produce a value on each line, however, the calculation is not working as I need it to. It is calculating the average for the current line and the lines above but this is not what I need. What I need is Sales/Target as a % for each individual line, bearing in mind that the Sales and Target values are accumulated.
Any further thoughts?