Thank you for contacting us.
The online demo below presents how Calculated Fields
(the average fields that appear for each item) and also Calculated Item could b created.
For the purported of your application you should simply create only a Calculated Item
(the "Forecast for 1999" item in the demo) which calculates the average value.
I hope this helps.
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.