I need to define some Hierarches in a pivot table with json data (not olap/xmla).
I can't find an example of this, the only example of Local Binding (http://demos.telerik.com/kendo-ui/pivotgrid/local-flat-data-binding) is very simple.
In this example, "All Categories" and "All Product" are two different ways to separate the data. What i need is a nested relation Category -> Product, so i can't view mesaures by product if i don't open the category first.
An example of this can be viewed on the "Basic Usage" example (http://demos.telerik.com/kendo-ui/pivotgrid/index). If you drag "Customer" fields into "ROWS" section, you will see nested fields in the pivot table (All Customes -> Australia, Canada, France...). See the image.
Any advice to configure the hierarchies?