jQuery(document).ready(function(){
var grid = jQuery("#grid").jqGrid('jqPivot',
"data.json",

{

xDimension : [
{
dataName: 'date_visit.year',
align: 'center'
},
],
yDimension : [
{dataName: 'source.source_label'},
{dataName: 'browser'},

],
aggregates : [

{member: 'pageviews_sum', aggregator : 'sum', width:50, label:'Sum of pageviews', summaryType: 'sum'},

{member: 'pageviews_avg', aggregator : 'sum', width:50, label:'Average of pageviews', summaryType: 'sum'},

],
rowTotals: false,
colTotals : false

},
// grid options
{
groupingView : {
hideFirstGroupCol : true
},
gridview: false,
loadtext: 'Bitte warten',
loadui: 'block',
shrinkToFit:false,
rowNum : 10,
pager: "#pager",
caption: 'webvisits'

},
{ reader : 'cells' }

);

});

{
"summary": {},
"remainder": {},
"cells": [
{
"source.source_label": "Direct link",
"pageviews_sum": 116010,
"pageviews_avg": 20,
"date_visit.year": 2012,
"source.source_id": "Direct_link",
"browser": "Chrome"
},
{
"source.source_label": "Direct link",
"pageviews_sum": 117321,
"pageviews_avg": 20,
"date_visit.year": 2012,
"source.source_id": "Direct_link",
"browser": "Firefox"
},
{
"source.source_label": "Direct link",
"pageviews_sum": 119346,
"pageviews_avg": 20,
"date_visit.year": 2012,
"source.source_id": "Direct_link",
"browser": "Lynx"
},
{
"source.source_label": "Unknown",
"pageviews_sum": 115723,
"pageviews_avg": 20,
"date_visit.year": 2012,
"source.source_id": "Unknown",
"browser": "Chrome"
},
{
"source.source_label": "Unknown",
"pageviews_sum": 112487,
"pageviews_avg": 20,
"date_visit.year": 2012,
"source.source_id": "Unknown",
"browser": "Firefox"
},
{
"source.source_label": "Unknown",
"pageviews_sum": 112685,
"pageviews_avg": 20,
"date_visit.year": 2012,
"source.source_id": "Unknown",
"browser": "Lynx"
},
{
"source.source_label": "Web search",
"pageviews_sum": 114041,
"pageviews_avg": 20,
"date_visit.year": 2012,
"source.source_id": "Web_search",
"browser": "Chrome"
},
{
"source.source_label": "Web search",
"pageviews_sum": 112181,
"pageviews_avg": 20,
"date_visit.year": 2012,
"source.source_id": "Web_search",
"browser": "Firefox"
},
{
"source.source_label": "Web search",
"pageviews_sum": 117329,
"pageviews_avg": 20,
"date_visit.year": 2012,
"source.source_id": "Web_search",
"browser": "Lynx"
},
{
"source.source_label": "Direct link",
"pageviews_sum": 113345,
"pageviews_avg": 20,
"date_visit.year": 2013,
"source.source_id": "Direct_link",
"browser": "Chrome"
},
{
"source.source_label": "Direct link",
"pageviews_sum": 111848,
"pageviews_avg": 20,
"date_visit.year": 2013,
"source.source_id": "Direct_link",
"browser": "Firefox"
},
{
"source.source_label": "Direct link",
"pageviews_sum": 111196,
"pageviews_avg": 20,
"date_visit.year": 2013,
"source.source_id": "Direct_link",
"browser": "Lynx"
},
{
"source.source_label": "Unknown",
"pageviews_sum": 112940,
"pageviews_avg": 20,
"date_visit.year": 2013,
"source.source_id": "Unknown",
"browser": "Chrome"
},
{
"source.source_label": "Unknown",
"pageviews_sum": 114079,
"pageviews_avg": 20,
"date_visit.year": 2013,
"source.source_id": "Unknown",
"browser": "Firefox"
},
{
"source.source_label": "Unknown",
"pageviews_sum": 113435,
"pageviews_avg": 20,
"date_visit.year": 2013,
"source.source_id": "Unknown",
"browser": "Lynx"
},
{
"source.source_label": "Web search",
"pageviews_sum": 114373,
"pageviews_avg": 20,
"date_visit.year": 2013,
"source.source_id": "Web_search",
"browser": "Chrome"
},
{
"source.source_label": "Web search",
"pageviews_sum": 111530,
"pageviews_avg": 20,
"date_visit.year": 2013,
"source.source_id": "Web_search",
"browser": "Firefox"
},
{
"source.source_label": "Web search",
"pageviews_sum": 114705,
"pageviews_avg": 20,
"date_visit.year": 2013,
"source.source_id": "Web_search",
"browser": "Lynx"
}
],
"aggregates": [
"pageviews_sum",
"pageviews_avg"
],
"cell": [],
"levels": {
"source": [
"source"
],
"date_visit": [
"year"
],
"browser": [
"browser"
]
}
}