Calculating Yearly Projected Amount

[shilabrow]

I have a dataset that I group with Pivot table to get the yearly amount by each Category. However for 2014 - amount to date only reflect January - April. I want to calculate the projected 2014 Total. Can I use Pivot table to achieve this cos I need to Pivot chart it automatically as well. Please help thanks!! Any other suggested help will be useful as well. Much appreciated!!

Category Yr2011 Yr2012 Yr2013 Yr2014
Food 200 250 260 45
Drinks 180 200 240 50
Salad 300 310 280 75


Snacks 400 420 440 110