pivotgridlocaldata.js

$(document).ready(function () {
    var pivotgrid = $("#pivotgrid").kendoPivotGrid({
        columnWidth: 120,
        height: 275,
        dataSource: {
            data: leaveData,
            schema: {
                model: {
                    fields: {
                        Employee: { type: "string" },
                        Start: { type: "date" },
                        End: {  type: "date" },
                        Type: { type: "string" },
                        Days: { type:"number" }
                    }
                },
                cube: {
                    dimensions: {
                        Employee: { },
                        Type: {  }
                        
                    },
                    measures: {
                        "Sum": { field: "Days",aggregate: "sum" }
                    }
                }
            },
          	columns:[{name:"Type",expand:true}],
            rows: [{ name: "Employee", expand: true }],
            measures: ["Sum"]
        }
    }).data("kendoPivotGrid");
});