Install Pivot

dataProvider = new RealGrid.LocalDataProvider();
//Create pivot object
pivot = new RealPivot("realpivot");
pivot.setDataProvider(dataProvider);

var fields = [{
     fieldName:"Domestic/Imported"
},{
     fieldName:"Country"
},{
     fieldName:"Brand number"
},{
     fieldName:"Brand Name"
},{
     fieldName:"Model number"
},{
     fieldName:"Model name"
},{
     fieldName:"Color number"
},{
     fieldName:"Color"
},{
     fieldName:"Sale Date",
     dataType:"datetime",
     datetimeFormat:"yyyy-MM-dd"
},{
     fieldName:"Sales Quantity",
     dataType:"number"
},{
     fieldName:"Vehicle price",
     dataType:"number"
},{
     fieldName:"Car type"
},{
     fieldName:"Fuel"
}];
 
dataProvider.setFields(fields);
 
pivot.setFieldMapping([{
     name: "Country",
     sourceField: "Country"
},{
     name: "Brand name",
     sourceField: "Brand Name"
},{
     name: "Sales Quarter",
     sourceField: "Sale Date",
     dateType:"quarter",
     fieldHeader:"branch",
     displayFormat: "${value}quarter",
     summaryFormat: "${value}Quarter Sum"
},{
     name: "Year of sale",
     sourceField: "Sale Date",
     dateType: "year",
     fieldHeader: "Year",
     displayFormat: "${value}year",
     summaryFormat: "Sum of ${value} years"
},{
     name: "Sale Month",
     sourceField: "Sale Date",
     dateType: "month",
     fieldHeader: "month",
     displayFormat: "${value}month",
     summaryFormat: "${value}monthly sum"
},{
     name: "Sales Quantity",
     sourceField: "Sales Quantity",
     numberFormat:"#,##0"
},{
     name: "Vehicle price",
     sourceField: "Vehicle price",
     numberFormat:"#,##0"
},{
     name:"Car type",
     sourceField:"Car type"
}]);
 
pivot.setPivotFields({
     columns: ["Sales Quarter","Sales Month"],
     rows: ["Brand Name","Car Model"],
     values: [{
         name: "Vehicle price",
         expression: "sum"
     }, {
         name: "Sales Quantity",
         expression: "sum"
     }]
});

$.ajax({
     url: "/data/pivotDataSet.json",
     success: function (data) {
         dataProvider.fillJsonData(data,{count:5000});
     },
     complete: function(data){
     }
});

pivot.drawView();