You can use PivotGridCalculatedItem
and manually create the logic for your calculations on server-side, as demonstrated in the following online demo (Forecast for 1999 group
Detailed information on this matter is also available in the following help article:
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.