$(function(){
pageInit();
});
function pageInit(){
jQuery("#pgrid3").jqGrid('jqPivot',
"data.json",
// pivot options
{
xDimension : [
{
dataName: 'CategoryName',
width:90
},{
dataName: 'ProductName'
}
],
yDimension : [
{
dataName: 'Country',
converter : function(value, xData, yData){
return 'TotalCountry';
}
},{
dataName: 'Country'
}
],
aggregates : [
{
member : 'Price',
aggregator : 'sum',
width:50,
formatter:'number',
align:'right',
summaryType: 'sum'
}
]
},
// grid options
{
width: 700,
rowNum : 10,
pager: "#ppager3",
caption: "Columns groups"
});
}
