Currently the component is very limited to OLAP. Please implement PivotGrid with features like filtering and sorting to flat data, as well as is done in normal grids.
By definition the purpose of a Pivot Grid widget is to consume and display data from OLAP source, Rech. Yet you can generate 'flat' data and pass it to the widget as presented in this example: http://demos.telerik.com/kendo-ui/pivotgrid/local-flat-data-binding (examine the product.js file structure from the local distribution of the examples)
You could do it like this: http://kendoui-feedback.telerik.com/forums/127393-telerik-kendo-ui-feedback/suggestions/9218646-implement-odata-aggregation-extensions-or-helper