You really need to add sorting to your Kendo UI pivotgrid for flat/local data sources. The entire point of a pivot grid is to analyze data. We did a POC with it for our salesmen. The feedback was: "It's almost useless if I can't sort it and see my top and bottom sellers, etc...". So, we're swapping out the pivotgrid for Infragistics Ignite UI. It's a shame too, cause most everything else is there.