profit Margin - lookup(profit margin,-1) Will do the work
Compute Using Year and Restart every Product
Hope this helps
Thanks Naveen for the quick reply, though not too good on the computation/formula calculation part, so if you can elaborate further, apologies.
thanks Naveen much appreciated for your help.