1、编写如下jsp页面（注意正确引入相关基础ExtJs的库）：
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Ext JS PivotGrid Sample</title>
<!-- GC -->
<link rel="stylesheet" type="text/css" href="../../resources/css/ext-all.css" />
<link rel="stylesheet" type="text/css" href="../shared/examples.css" />
<!-- ExtJS library: base/adapter -->
<script type="text/javascript" src="../../adapter/ext/ext-base.js"></script>
<!-- ExtJS library: all widgets -->
<script type="text/javascript" src="../../ext-all.js"></script>
<script type="text/javascript" src="simple.js"></script>
</head>
<body id="docbody">
<h1>Pivot Grid example</h1>
<p>This example shows how to create a Pivot Grid backed by an Ext.data.Store.</p>
<p>
In this example we are reading a set of 300 records from the server and then pivoting them around Person and Product (on the left axis)<br />
and City and Year (on the top axis). The data are combined automatically, in this case breaking down sales by product and person <br />over time.
</p>
<p><a href="simple.js">The example code</a> is not minified, so it's readable. </p>
</body>
</html>
2、以下为核心功能代码
/*
This file is part of Ext JS 3.4
Copyright (c) 2011-2013 Sencha Inc
Contact: http://www.sencha.com/contact
GNU General Public License Usage
This file may be used under the terms of the GNU General Public License version 3.0 as
published by the Free Software Foundation and appearing in the file LICENSE included in the
packaging of this file.
Please review the following information to ensure the GNU General Public License version 3.0
requirements will be met: http://www.gnu.org/copyleft/gpl.html.
If you are unsure which license is appropriate for your use, please contact the sales department
at http://www.sencha.com/contact.
Build date: 2013-04-03 15:07:25
*/
Ext.onReady(function() {
var SaleRecord = Ext.data.Record.create([
{name: 'person', type: 'string'},
{name: 'product', type: 'string'},
{name: 'city', type: 'string'},
{name: 'state', type: 'string'},
{name: 'month', type: 'int'},
{name: 'quarter', type: 'int'},
{name: 'year', type: 'int'},
{name: 'quantity', type: 'int'},
{name: 'value', type: 'int'}
]);
var myStore = new Ext.data.Store({
url: 'simple.json',
autoLoad: true,
reader: new Ext.data.JsonReader({
root: 'rows',
idProperty: 'id'
}, SaleRecord)
});
var pivotGrid = new Ext.grid.PivotGrid({
title : 'PivotGrid example',
width : 800,
height : 259,
renderTo : 'docbody',
store : myStore,
aggregator: 'sum',
measure : 'value',
viewConfig: {
title: 'Sales Performance'
},
leftAxis: [
{
width: 80,
dataIndex: 'person'
},
{
width: 90,
dataIndex: 'product'
}
],
topAxis: [
{
dataIndex: 'year'
},
{
dataIndex: 'city'
}
]
});
});
3、返回的数据格式要求：
{
"rows": [{
"id": 1,
"product": "Ladder",
"city": "London",
"state": "NY",
"quantity": 5568,
"value": 17,
"month": 11,
"quarter": 3,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 2,
"product": "Spanner",
"city": "San Francisco",
"state": "TX",
"quantity": 7639,
"value": 43,
"month": 4,
"quarter": 3,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 3,
"product": "Chair",
"city": "Austin",
"state": "AZ",
"quantity": 3770,
"value": 22,
"month": 5,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 4,
"product": "Ladder",
"city": "San Francisco",
"state": "CA",
"quantity": 1494,
"value": 37,
"month": 11,
"quarter": 2,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 5,
"product": "Spanner",
"city": "Austin",
"state": "TX",
"quantity": 5854,
"value": 25,
"month": 10,
"quarter": 4,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 6,
"product": "Ladder",
"city": "London",
"state": "NY",
"quantity": 8237,
"value": 34,
"month": 7,
"quarter": 4,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 7,
"product": "Ladder",
"city": "Palo Alto",
"state": "TX",
"quantity": 4188,
"value": 26,
"month": 3,
"quarter": 3,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 8,
"product": "Spanner",
"city": "Palo Alto",
"state": "UK",
"quantity": 900,
"value": 7,
"month": 4,
"quarter": 1,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 9,
"product": "Chair",
"city": "Austin",
"state": "AZ",
"quantity": 9320,
"value": 38,
"month": 11,
"quarter": 1,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 10,
"product": "Spanner",
"city": "Austin",
"state": "UK",
"quantity": 9510,
"value": 39,
"month": 7,
"quarter": 2,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 11,
"product": "Ladder",
"city": "London",
"state": "AZ",
"quantity": 240,
"value": 26,
"month": 8,
"quarter": 3,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 12,
"product": "Chair",
"city": "Palo Alto",
"state": "TX",
"quantity": 3815,
"value": 9,
"month": 11,
"quarter": 1,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 13,
"product": "Spanner",
"city": "Austin",
"state": "AZ",
"quantity": 5858,
"value": 21,
"month": 11,
"quarter": 2,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 14,
"product": "Chair",
"city": "San Francisco",
"state": "AZ",
"quantity": 244,
"value": 11,
"month": 2,
"quarter": 2,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 15,
"product": "Ladder",
"city": "London",
"state": "TX",
"quantity": 2393,
"value": 37,
"month": 9,
"quarter": 1,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 16,
"product": "Chair",
"city": "London",
"state": "TX",
"quantity": 6990,
"value": 7,
"month": 5,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 17,
"product": "Chair",
"city": "London",
"state": "AZ",
"quantity": 8787,
"value": 26,
"month": 11,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 18,
"product": "Spanner",
"city": "London",
"state": "TX",
"quantity": 5845,
"value": 0,
"month": 2,
"quarter": 4,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 19,
"product": "Chair",
"city": "Palo Alto",
"state": "NY",
"quantity": 6864,
"value": 33,
"month": 12,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 20,
"product": "Spanner",
"city": "San Francisco",
"state": "CA",
"quantity": 2332,
"value": 22,
"month": 7,
"quarter": 3,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 21,
"product": "Ladder",
"city": "London",
"state": "TX",
"quantity": 6142,
"value": 26,
"month": 12,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 22,
"product": "Spanner",
"city": "San Francisco",
"state": "TX",
"quantity": 723,
"value": 12,
"month": 2,
"quarter": 1,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 23,
"product": "Spanner",
"city": "Palo Alto",
"state": "UK",
"quantity": 3438,
"value": 40,
"month": 5,
"quarter": 2,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 24,
"product": "Chair",
"city": "London",
"state": "TX",
"quantity": 2036,
"value": 46,
"month": 2,
"quarter": 1,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 25,
"product": "Spanner",
"city": "Palo Alto",
"state": "UK",
"quantity": 325,
"value": 5,
"month": 12,
"quarter": 2,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 26,
"product": "Ladder",
"city": "San Francisco",
"state": "NY",
"quantity": 3536,
"value": 17,
"month": 1,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 27,
"product": "Ladder",
"city": "Austin",
"state": "UK",
"quantity": 2557,
"value": 34,
"month": 4,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 28,
"product": "Spanner",
"city": "London",
"state": "TX",
"quantity": 578,
"value": 23,
"month": 7,
"quarter": 1,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 29,
"product": "Ladder",
"city": "San Francisco",
"state": "UK",
"quantity": 3510,
"value": 29,
"month": 11,
"quarter": 4,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 30,
"product": "Spanner",
"city": "Palo Alto",
"state": "NY",
"quantity": 1304,
"value": 10,
"month": 10,
"quarter": 2,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 31,
"product": "Spanner",
"city": "London",
"state": "CA",
"quantity": 2538,
"value": 25,
"month": 8,
"quarter": 1,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 32,
"product": "Spanner",
"city": "London",
"state": "AZ",
"quantity": 1777,
"value": 30,
"month": 3,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 33,
"product": "Spanner",
"city": "San Francisco",
"state": "CA",
"quantity": 9682,
"value": 14,
"month": 9,
"quarter": 1,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 34,
"product": "Spanner",
"city": "Austin",
"state": "NY",
"quantity": 7707,
"value": 31,
"month": 10,
"quarter": 4,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 35,
"product": "Chair",
"city": "San Francisco",
"state": "AZ",
"quantity": 4240,
"value": 15,
"month": 3,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 36,
"product": "Spanner",
"city": "London",
"state": "AZ",
"quantity": 7127,
"value": 49,
"month": 3,
"quarter": 4,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 37,
"product": "Chair",
"city": "London",
"state": "TX",
"quantity": 8131,
"value": 45,
"month": 4,
"quarter": 1,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 38,
"product": "Chair",
"city": "San Francisco",
"state": "UK",
"quantity": 6493,
"value": 5,
"month": 6,
"quarter": 3,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 39,
"product": "Chair",
"city": "London",
"state": "NY",
"quantity": 3392,
"value": 47,
"month": 5,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 40,
"product": "Ladder",
"city": "London",
"state": "NY",
"quantity": 6399,
"value": 18,
"month": 7,
"quarter": 3,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 41,
"product": "Ladder",
"city": "San Francisco",
"state": "AZ",
"quantity": 1564,
"value": 14,
"month": 5,
"quarter": 3,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 42,
"product": "Ladder",
"city": "San Francisco",
"state": "NY",
"quantity": 6174,
"value": 6,
"month": 7,
"quarter": 4,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 43,
"product": "Chair",
"city": "San Francisco",
"state": "AZ",
"quantity": 2451,
"value": 12,
"month": 4,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 44,
"product": "Spanner",
"city": "San Francisco",
"state": "UK",
"quantity": 1637,
"value": 39,
"month": 5,
"quarter": 3,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 45,
"product": "Ladder",
"city": "Austin",
"state": "UK",
"quantity": 1078,
"value": 7,
"month": 6,
"quarter": 2,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 46,
"product": "Chair",
"city": "Palo Alto",
"state": "TX",
"quantity": 791,
"value": 38,
"month": 7,
"quarter": 3,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 47,
"product": "Ladder",
"city": "Austin",
"state": "CA",
"quantity": 2211,
"value": 21,
"month": 5,
"quarter": 1,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 48,
"product": "Spanner",
"city": "San Francisco",
"state": "NY",
"quantity": 55,
"value": 39,
"month": 12,
"quarter": 4,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 49,
"product": "Chair",
"city": "London",
"state": "UK",
"quantity": 4275,
"value": 21,
"month": 10,
"quarter": 2,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 50,
"product": "Spanner",
"city": "London",
"state": "TX",
"quantity": 10,
"value": 30,
"month": 8,
"quarter": 4,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 51,
"product": "Chair",
"city": "Austin",
"state": "TX",
"quantity": 5800,
"value": 25,
"month": 1,
"quarter": 3,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 52,
"product": "Chair",
"city": "Austin",
"state": "UK",
"quantity": 9346,
"value": 32,
"month": 7,
"quarter": 4,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 53,
"product": "Spanner",
"city": "San Francisco",
"state": "AZ",
"quantity": 9725,
"value": 8,
"month": 1,
"quarter": 3,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 54,
"product": "Spanner",
"city": "Austin",
"state": "UK",
"quantity": 3439,
"value": 33,
"month": 5,
"quarter": 4,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 55,
"product": "Chair",
"city": "San Francisco",
"state": "NY",
"quantity": 7070,
"value": 25,
"month": 4,
"quarter": 4,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 56,
"product": "Chair",
"city": "London",
"state": "CA",
"quantity": 1141,
"value": 14,
"month": 9,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 57,
"product": "Ladder",
"city": "Palo Alto",
"state": "UK",
"quantity": 8061,
"value": 39,
"month": 12,
"quarter": 3,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 58,
"product": "Spanner",
"city": "Austin",
"state": "UK",
"quantity": 7770,
"value": 19,
"month": 2,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 59,
"product": "Ladder",
"city": "London",
"state": "NY",
"quantity": 738,
"value": 6,
"month": 10,
"quarter": 4,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 60,
"product": "Spanner",
"city": "London",
"state": "TX",
"quantity": 8904,
"value": 18,
"month": 1,
"quarter": 1,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 61,
"product": "Ladder",
"city": "San Francisco",
"state": "CA",
"quantity": 5845,
"value": 25,
"month": 1,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 62,
"product": "Spanner",
"city": "Austin",
"state": "AZ",
"quantity": 9010,
"value": 1,
"month": 1,
"quarter": 2,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 63,
"product": "Ladder",
"city": "Austin",
"state": "TX",
"quantity": 3042,
"value": 18,
"month": 11,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 64,
"product": "Chair",
"city": "London",
"state": "UK",
"quantity": 1025,
"value": 15,
"month": 10,
"quarter": 1,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 65,
"product": "Ladder",
"city": "San Francisco",
"state": "TX",
"quantity": 4247,
"value": 31,
"month": 9,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 66,
"product": "Chair",
"city": "San Francisco",
"state": "AZ",
"quantity": 7707,
"value": 34,
"month": 3,
"quarter": 1,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 67,
"product": "Ladder",
"city": "Palo Alto",
"state": "UK",
"quantity": 9051,
"value": 14,
"month": 11,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 68,
"product": "Chair",
"city": "Austin",
"state": "CA",
"quantity": 1821,
"value": 44,
"month": 9,
"quarter": 2,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 69,
"product": "Ladder",
"city": "Austin",
"state": "UK",
"quantity": 9625,
"value": 9,
"month": 4,
"quarter": 2,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 70,
"product": "Ladder",
"city": "London",
"state": "TX",
"quantity": 8495,
"value": 25,
"month": 2,
"quarter": 4,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 71,
"product": "Spanner",
"city": "Austin",
"state": "CA",
"quantity": 3698,
"value": 11,
"month": 4,
"quarter": 2,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 72,
"product": "Ladder",
"city": "Palo Alto",
"state": "NY",
"quantity": 2779,
"value": 44,
"month": 2,
"quarter": 2,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 73,
"product": "Ladder",
"city": "Palo Alto",
"state": "NY",
"quantity": 9791,
"value": 15,
"month": 6,
"quarter": 3,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 74,
"product": "Chair",
"city": "Austin",
"state": "NY",
"quantity": 1990,
"value": 43,
"month": 12,
"quarter": 4,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 75,
"product": "Spanner",
"city": "San Francisco",
"state": "CA",
"quantity": 249,
"value": 35,
"month": 11,
"quarter": 3,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 76,
"product": "Ladder",
"city": "Palo Alto",
"state": "NY",
"quantity": 4796,
"value": 27,
"month": 5,
"quarter": 4,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 77,
"product": "Spanner",
"city": "Palo Alto",
"state": "CA",
"quantity": 5771,
"value": 9,
"month": 9,
"quarter": 1,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 78,
"product": "Chair",
"city": "San Francisco",
"state": "TX",
"quantity": 3720,
"value": 21,
"month": 9,
"quarter": 4,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 79,
"product": "Spanner",
"city": "London",
"state": "TX",
"quantity": 7890,
"value": 44,
"month": 6,
"quarter": 2,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 80,
"product": "Ladder",
"city": "San Francisco",
"state": "NY",
"quantity": 1061,
"value": 31,
"month": 2,
"quarter": 4,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 81,
"product": "Chair",
"city": "Palo Alto",
"state": "NY",
"quantity": 1357,
"value": 49,
"month": 5,
"quarter": 1,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 82,
"product": "Spanner",
"city": "Austin",
"state": "NY",
"quantity": 2783,
"value": 45,
"month": 12,
"quarter": 3,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 83,
"product": "Chair",
"city": "Austin",
"state": "UK",
"quantity": 9493,
"value": 42,
"month": 7,
"quarter": 2,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 84,
"product": "Ladder",
"city": "Palo Alto",
"state": "TX",
"quantity": 7571,
"value": 29,
"month": 9,
"quarter": 3,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 85,
"product": "Chair",
"city": "London",
"state": "CA",
"quantity": 8163,
"value": 4,
"month": 1,
"quarter": 2,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 86,
"product": "Ladder",
"city": "San Francisco",
"state": "UK",
"quantity": 4710,
"value": 30,
"month": 1,
"quarter": 4,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 87,
"product": "Spanner",
"city": "Austin",
"state": "AZ",
"quantity": 3277,
"value": 39,
"month": 5,
"quarter": 2,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 88,
"product": "Ladder",
"city": "London",
"state": "TX",
"quantity": 6505,
"value": 44,
"month": 8,
"quarter": 1,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 89,
"product": "Ladder",
"city": "San Francisco",
"state": "UK",
"quantity": 532,
"value": 30,
"month": 3,
"quarter": 2,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 90,
"product": "Ladder",
"city": "Austin",
"state": "CA",
"quantity": 2975,
"value": 4,
"month": 5,
"quarter": 3,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 91,
"product": "Chair",
"city": "San Francisco",
"state": "AZ",
"quantity": 6483,
"value": 24,
"month": 2,
"quarter": 3,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 92,
"product": "Spanner",
"city": "Palo Alto",
"state": "AZ",
"quantity": 9744,
"value": 30,
"month": 2,
"quarter": 4,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 93,
"product": "Chair",
"city": "London",
"state": "NY",
"quantity": 4546,
"value": 35,
"month": 10,
"quarter": 4,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 94,
"product": "Ladder",
"city": "London",
"state": "CA",
"quantity": 5530,
"value": 42,
"month": 12,
"quarter": 3,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 95,
"product": "Chair",
"city": "Austin",
"state": "TX",
"quantity": 7587,
"value": 25,
"month": 2,
"quarter": 1,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 96,
"product": "Chair",
"city": "San Francisco",
"state": "CA",
"quantity": 8964,
"value": 31,
"month": 11,
"quarter": 1,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 97,
"product": "Ladder",
"city": "London",
"state": "UK",
"quantity": 2239,
"value": 14,
"month": 1,
"quarter": 2,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 98,
"product": "Spanner",
"city": "Austin",
"state": "CA",
"quantity": 2888,
"value": 30,
"month": 6,
"quarter": 1,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 99,
"product": "Spanner",
"city": "London",
"state": "NY",
"quantity": 7904,
"value": 43,
"month": 12,
"quarter": 1,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 100,
"product": "Spanner",
"city": "San Francisco",
"state": "NY",
"quantity": 4529,
"value": 14,
"month": 3,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 101,
"product": "Ladder",
"city": "Austin",
"state": "CA",
"quantity": 5235,
"value": 12,
"month": 10,
"quarter": 3,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 102,
"product": "Spanner",
"city": "Austin",
"state": "UK",
"quantity": 9177,
"value": 34,
"month": 10,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 103,
"product": "Spanner",
"city": "Palo Alto",
"state": "AZ",
"quantity": 1024,
"value": 12,
"month": 1,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 104,
"product": "Ladder",
"city": "San Francisco",
"state": "UK",
"quantity": 2651,
"value": 43,
"month": 9,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 105,
"product": "Chair",
"city": "London",
"state": "UK",
"quantity": 4088,
"value": 41,
"month": 7,
"quarter": 4,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 106,
"product": "Ladder",
"city": "Palo Alto",
"state": "NY",
"quantity": 6358,
"value": 40,
"month": 12,
"quarter": 2,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 107,
"product": "Ladder",
"city": "San Francisco",
"state": "NY",
"quantity": 2881,
"value": 37,
"month": 7,
"quarter": 4,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 108,
"product": "Ladder",
"city": "Austin",
"state": "CA",
"quantity": 6559,
"value": 27,
"month": 3,
"quarter": 2,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 109,
"product": "Ladder",
"city": "Austin",
"state": "UK",
"quantity": 6755,
"value": 49,
"month": 8,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 110,
"product": "Ladder",
"city": "Austin",
"state": "UK",
"quantity": 1252,
"value": 13,
"month": 11,
"quarter": 2,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 111,
"product": "Spanner",
"city": "London",
"state": "TX",
"quantity": 7356,
"value": 37,
"month": 5,
"quarter": 4,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 112,
"product": "Ladder",
"city": "Austin",
"state": "CA",
"quantity": 3224,
"value": 18,
"month": 12,
"quarter": 1,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 113,
"product": "Spanner",
"city": "Austin",
"state": "CA",
"quantity": 5814,
"value": 8,
"month": 3,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 114,
"product": "Chair",
"city": "San Francisco",
"state": "NY",
"quantity": 1087,
"value": 39,
"month": 7,
"quarter": 4,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 115,
"product": "Ladder",
"city": "San Francisco",
"state": "TX",
"quantity": 2705,
"value": 24,
"month": 10,
"quarter": 3,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 116,
"product": "Chair",
"city": "San Francisco",
"state": "UK",
"quantity": 5421,
"value": 48,
"month": 10,
"quarter": 1,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 117,
"product": "Ladder",
"city": "Austin",
"state": "UK",
"quantity": 6247,
"value": 48,
"month": 10,
"quarter": 1,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 118,
"product": "Chair",
"city": "Palo Alto",
"state": "TX",
"quantity": 999,
"value": 40,
"month": 2,
"quarter": 2,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 119,
"product": "Ladder",
"city": "Palo Alto",
"state": "UK",
"quantity": 4826,
"value": 42,
"month": 9,
"quarter": 4,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 120,
"product": "Chair",
"city": "Palo Alto",
"state": "CA",
"quantity": 5678,
"value": 21,
"month": 1,
"quarter": 4,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 121,
"product": "Ladder",
"city": "Austin",
"state": "TX",
"quantity": 9906,
"value": 37,
"month": 2,
"quarter": 3,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 122,
"product": "Ladder",
"city": "London",
"state": "TX",
"quantity": 8478,
"value": 21,
"month": 7,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 123,
"product": "Chair",
"city": "Austin",
"state": "NY",
"quantity": 1490,
"value": 3,
"month": 11,
"quarter": 1,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 124,
"product": "Chair",
"city": "Austin",
"state": "CA",
"quantity": 5464,
"value": 24,
"month": 9,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 125,
"product": "Spanner",
"city": "San Francisco",
"state": "AZ",
"quantity": 2692,
"value": 42,
"month": 9,
"quarter": 4,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 126,
"product": "Chair",
"city": "Palo Alto",
"state": "NY",
"quantity": 7116,
"value": 36,
"month": 9,
"quarter": 1,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 127,
"product": "Ladder",
"city": "San Francisco",
"state": "CA",
"quantity": 1726,
"value": 17,
"month": 4,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 128,
"product": "Ladder",
"city": "Palo Alto",
"state": "AZ",
"quantity": 7161,
"value": 28,
"month": 8,
"quarter": 2,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 129,
"product": "Spanner",
"city": "Austin",
"state": "NY",
"quantity": 9584,
"value": 10,
"month": 2,
"quarter": 4,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 130,
"product": "Spanner",
"city": "London",
"state": "UK",
"quantity": 1517,
"value": 27,
"month": 8,
"quarter": 1,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 131,
"product": "Spanner",
"city": "San Francisco",
"state": "AZ",
"quantity": 6650,
"value": 48,
"month": 2,
"quarter": 4,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 132,
"product": "Spanner",
"city": "Austin",
"state": "NY",
"quantity": 8422,
"value": 17,
"month": 3,
"quarter": 3,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 133,
"product": "Ladder",
"city": "Palo Alto",
"state": "CA",
"quantity": 9920,
"value": 0,
"month": 12,
"quarter": 4,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 134,
"product": "Ladder",
"city": "Palo Alto",
"state": "AZ",
"quantity": 8672,
"value": 21,
"month": 7,
"quarter": 4,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 135,
"product": "Chair",
"city": "San Francisco",
"state": "UK",
"quantity": 333,
"value": 40,
"month": 5,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 136,
"product": "Chair",
"city": "London",
"state": "AZ",
"quantity": 6684,
"value": 3,
"month": 12,
"quarter": 4,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 137,
"product": "Ladder",
"city": "London",
"state": "TX",
"quantity": 2648,
"value": 26,
"month": 1,
"quarter": 1,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 138,
"product": "Ladder",
"city": "Palo Alto",
"state": "TX",
"quantity": 7504,
"value": 39,
"month": 2,
"quarter": 1,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 139,
"product": "Chair",
"city": "Palo Alto",
"state": "CA",
"quantity": 3008,
"value": 36,
"month": 4,
"quarter": 2,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 140,
"product": "Spanner",
"city": "San Francisco",
"state": "CA",
"quantity": 4715,
"value": 3,
"month": 1,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 141,
"product": "Chair",
"city": "San Francisco",
"state": "TX",
"quantity": 2221,
"value": 22,
"month": 9,
"quarter": 2,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 142,
"product": "Chair",
"city": "London",
"state": "NY",
"quantity": 6970,
"value": 12,
"month": 1,
"quarter": 3,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 143,
"product": "Chair",
"city": "London",
"state": "TX",
"quantity": 9882,
"value": 25,
"month": 12,
"quarter": 1,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 144,
"product": "Ladder",
"city": "Palo Alto",
"state": "UK",
"quantity": 6746,
"value": 15,
"month": 2,
"quarter": 1,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 145,
"product": "Ladder",
"city": "London",
"state": "AZ",
"quantity": 902,
"value": 25,
"month": 10,
"quarter": 2,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 146,
"product": "Chair",
"city": "Palo Alto",
"state": "NY",
"quantity": 3821,
"value": 35,
"month": 5,
"quarter": 4,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 147,
"product": "Spanner",
"city": "San Francisco",
"state": "UK",
"quantity": 6714,
"value": 34,
"month": 3,
"quarter": 1,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 148,
"product": "Ladder",
"city": "London",
"state": "NY",
"quantity": 8759,
"value": 8,
"month": 4,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 149,
"product": "Spanner",
"city": "Palo Alto",
"state": "CA",
"quantity": 410,
"value": 16,
"month": 1,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 150,
"product": "Ladder",
"city": "London",
"state": "AZ",
"quantity": 724,
"value": 23,
"month": 11,
"quarter": 4,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 151,
"product": "Chair",
"city": "San Francisco",
"state": "CA",
"quantity": 4328,
"value": 31,
"month": 5,
"quarter": 4,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 152,
"product": "Spanner",
"city": "San Francisco",
"state": "UK",
"quantity": 3752,
"value": 13,
"month": 7,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 153,
"product": "Chair",
"city": "Palo Alto",
"state": "NY",
"quantity": 729,
"value": 37,
"month": 4,
"quarter": 4,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 154,
"product": "Spanner",
"city": "London",
"state": "TX",
"quantity": 8842,
"value": 28,
"month": 7,
"quarter": 3,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 155,
"product": "Spanner",
"city": "Austin",
"state": "TX",
"quantity": 6459,
"value": 4,
"month": 3,
"quarter": 4,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 156,
"product": "Chair",
"city": "London",
"state": "NY",
"quantity": 7056,
"value": 5,
"month": 7,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 157,
"product": "Chair",
"city": "London",
"state": "CA",
"quantity": 2934,
"value": 40,
"month": 3,
"quarter": 2,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 158,
"product": "Ladder",
"city": "Austin",
"state": "TX",
"quantity": 9221,
"value": 35,
"month": 2,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 159,
"product": "Spanner",
"city": "Austin",
"state": "NY",
"quantity": 8122,
"value": 27,
"month": 8,
"quarter": 1,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 160,
"product": "Spanner",
"city": "Palo Alto",
"state": "NY",
"quantity": 5124,
"value": 31,
"month": 10,
"quarter": 1,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 161,
"product": "Ladder",
"city": "San Francisco",
"state": "NY",
"quantity": 203,
"value": 7,
"month": 4,
"quarter": 2,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 162,
"product": "Ladder",
"city": "London",
"state": "UK",
"quantity": 2575,
"value": 15,
"month": 6,
"quarter": 3,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 163,
"product": "Chair",
"city": "Austin",
"state": "AZ",
"quantity": 7705,
"value": 9,
"month": 7,
"quarter": 3,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 164,
"product": "Chair",
"city": "Austin",
"state": "CA",
"quantity": 915,
"value": 32,
"month": 3,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 165,
"product": "Ladder",
"city": "London",
"state": "NY",
"quantity": 4813,
"value": 46,
"month": 10,
"quarter": 2,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 166,
"product": "Ladder",
"city": "Palo Alto",
"state": "UK",
"quantity": 9269,
"value": 40,
"month": 12,
"quarter": 1,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 167,
"product": "Chair",
"city": "Austin",
"state": "AZ",
"quantity": 4875,
"value": 30,
"month": 7,
"quarter": 1,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 168,
"product": "Spanner",
"city": "London",
"state": "TX",
"quantity": 5029,
"value": 0,
"month": 1,
"quarter": 4,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 169,
"product": "Ladder",
"city": "Palo Alto",
"state": "AZ",
"quantity": 3101,
"value": 19,
"month": 11,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 170,
"product": "Spanner",
"city": "Palo Alto",
"state": "UK",
"quantity": 4863,
"value": 47,
"month": 3,
"quarter": 1,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 171,
"product": "Ladder",
"city": "Austin",
"state": "UK",
"quantity": 6769,
"value": 35,
"month": 4,
"quarter": 1,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 172,
"product": "Spanner",
"city": "Austin",
"state": "CA",
"quantity": 887,
"value": 29,
"month": 9,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 173,
"product": "Spanner",
"city": "San Francisco",
"state": "AZ",
"quantity": 7011,
"value": 42,
"month": 1,
"quarter": 2,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 174,
"product": "Ladder",
"city": "San Francisco",
"state": "NY",
"quantity": 6671,
"value": 24,
"month": 2,
"quarter": 1,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 175,
"product": "Spanner",
"city": "San Francisco",
"state": "TX",
"quantity": 3139,
"value": 15,
"month": 6,
"quarter": 2,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 176,
"product": "Chair",
"city": "Austin",
"state": "TX",
"quantity": 3600,
"value": 46,
"month": 10,
"quarter": 2,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 177,
"product": "Spanner",
"city": "London",
"state": "TX",
"quantity": 5178,
"value": 31,
"month": 6,
"quarter": 3,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 178,
"product": "Chair",
"city": "San Francisco",
"state": "CA",
"quantity": 7690,
"value": 38,
"month": 7,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 179,
"product": "Spanner",
"city": "San Francisco",
"state": "UK",
"quantity": 1460,
"value": 37,
"month": 6,
"quarter": 3,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 180,
"product": "Chair",
"city": "Palo Alto",
"state": "NY",
"quantity": 2330,
"value": 39,
"month": 1,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 181,
"product": "Spanner",
"city": "London",
"state": "AZ",
"quantity": 3033,
"value": 6,
"month": 8,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 182,
"product": "Spanner",
"city": "San Francisco",
"state": "UK",
"quantity": 713,
"value": 3,
"month": 4,
"quarter": 3,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 183,
"product": "Chair",
"city": "London",
"state": "TX",
"quantity": 91,
"value": 39,
"month": 4,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 184,
"product": "Ladder",
"city": "San Francisco",
"state": "AZ",
"quantity": 3532,
"value": 30,
"month": 9,
"quarter": 1,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 185,
"product": "Spanner",
"city": "London",
"state": "NY",
"quantity": 7627,
"value": 44,
"month": 5,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 186,
"product": "Chair",
"city": "London",
"state": "TX",
"quantity": 6921,
"value": 6,
"month": 3,
"quarter": 3,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 187,
"product": "Ladder",
"city": "Austin",
"state": "CA",
"quantity": 1216,
"value": 16,
"month": 10,
"quarter": 1,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 188,
"product": "Spanner",
"city": "Palo Alto",
"state": "CA",
"quantity": 7405,
"value": 29,
"month": 5,
"quarter": 1,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 189,
"product": "Ladder",
"city": "Austin",
"state": "NY",
"quantity": 474,
"value": 4,
"month": 9,
"quarter": 4,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 190,
"product": "Ladder",
"city": "San Francisco",
"state": "CA",
"quantity": 4265,
"value": 25,
"month": 12,
"quarter": 4,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 191,
"product": "Ladder",
"city": "London",
"state": "CA",
"quantity": 8432,
"value": 17,
"month": 6,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 192,
"product": "Ladder",
"city": "San Francisco",
"state": "UK",
"quantity": 4181,
"value": 25,
"month": 11,
"quarter": 2,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 193,
"product": "Ladder",
"city": "Austin",
"state": "AZ",
"quantity": 1592,
"value": 43,
"month": 10,
"quarter": 3,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 194,
"product": "Ladder",
"city": "Palo Alto",
"state": "CA",
"quantity": 1352,
"value": 46,
"month": 3,
"quarter": 4,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 195,
"product": "Chair",
"city": "Austin",
"state": "NY",
"quantity": 5151,
"value": 27,
"month": 7,
"quarter": 1,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 196,
"product": "Spanner",
"city": "Austin",
"state": "TX",
"quantity": 8746,
"value": 47,
"month": 3,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 197,
"product": "Chair",
"city": "Austin",
"state": "AZ",
"quantity": 9723,
"value": 15,
"month": 1,
"quarter": 3,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 198,
"product": "Chair",
"city": "San Francisco",
"state": "CA",
"quantity": 5054,
"value": 4,
"month": 11,
"quarter": 3,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 199,
"product": "Chair",
"city": "Palo Alto",
"state": "TX",
"quantity": 2325,
"value": 23,
"month": 12,
"quarter": 3,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 200,
"product": "Ladder",
"city": "San Francisco",
"state": "UK",
"quantity": 7271,
"value": 44,
"month": 5,
"quarter": 1,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 201,
"product": "Ladder",
"city": "Palo Alto",
"state": "AZ",
"quantity": 1892,
"value": 23,
"month": 9,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 202,
"product": "Ladder",
"city": "Palo Alto",
"state": "UK",
"quantity": 877,
"value": 36,
"month": 7,
"quarter": 4,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 203,
"product": "Spanner",
"city": "Palo Alto",
"state": "AZ",
"quantity": 6379,
"value": 47,
"month": 3,
"quarter": 1,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 204,
"product": "Chair",
"city": "Austin",
"state": "TX",
"quantity": 8045,
"value": 46,
"month": 7,
"quarter": 1,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 205,
"product": "Spanner",
"city": "Austin",
"state": "AZ",
"quantity": 1878,
"value": 48,
"month": 12,
"quarter": 4,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 206,
"product": "Chair",
"city": "San Francisco",
"state": "CA",
"quantity": 8201,
"value": 3,
"month": 12,
"quarter": 3,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 207,
"product": "Ladder",
"city": "Palo Alto",
"state": "UK",
"quantity": 5449,
"value": 32,
"month": 9,
"quarter": 3,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 208,
"product": "Spanner",
"city": "Palo Alto",
"state": "AZ",
"quantity": 1761,
"value": 5,
"month": 11,
"quarter": 3,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 209,
"product": "Ladder",
"city": "Palo Alto",
"state": "CA",
"quantity": 2839,
"value": 34,
"month": 2,
"quarter": 3,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 210,
"product": "Spanner",
"city": "London",
"state": "AZ",
"quantity": 8766,
"value": 30,
"month": 3,
"quarter": 2,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 211,
"product": "Chair",
"city": "Austin",
"state": "NY",
"quantity": 4331,
"value": 33,
"month": 3,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 212,
"product": "Chair",
"city": "Palo Alto",
"state": "CA",
"quantity": 2929,
"value": 32,
"month": 1,
"quarter": 3,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 213,
"product": "Ladder",
"city": "London",
"state": "CA",
"quantity": 357,
"value": 1,
"month": 1,
"quarter": 3,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 214,
"product": "Ladder",
"city": "Palo Alto",
"state": "TX",
"quantity": 4743,
"value": 32,
"month": 11,
"quarter": 1,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 215,
"product": "Ladder",
"city": "Palo Alto",
"state": "NY",
"quantity": 574,
"value": 8,
"month": 4,
"quarter": 1,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 216,
"product": "Ladder",
"city": "Palo Alto",
"state": "AZ",
"quantity": 0,
"value": 18,
"month": 2,
"quarter": 4,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 217,
"product": "Chair",
"city": "London",
"state": "TX",
"quantity": 9281,
"value": 21,
"month": 12,
"quarter": 4,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 218,
"product": "Chair",
"city": "Austin",
"state": "NY",
"quantity": 1687,
"value": 1,
"month": 7,
"quarter": 3,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 219,
"product": "Chair",
"city": "Austin",
"state": "AZ",
"quantity": 1347,
"value": 41,
"month": 12,
"quarter": 1,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 220,
"product": "Spanner",
"city": "London",
"state": "NY",
"quantity": 2116,
"value": 17,
"month": 6,
"quarter": 4,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 221,
"product": "Ladder",
"city": "London",
"state": "TX",
"quantity": 6572,
"value": 30,
"month": 3,
"quarter": 3,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 222,
"product": "Ladder",
"city": "Palo Alto",
"state": "CA",
"quantity": 3808,
"value": 45,
"month": 9,
"quarter": 2,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 223,
"product": "Spanner",
"city": "San Francisco",
"state": "UK",
"quantity": 1967,
"value": 47,
"month": 2,
"quarter": 2,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 224,
"product": "Chair",
"city": "London",
"state": "TX",
"quantity": 2676,
"value": 27,
"month": 6,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 225,
"product": "Chair",
"city": "San Francisco",
"state": "TX",
"quantity": 7940,
"value": 8,
"month": 6,
"quarter": 4,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 226,
"product": "Chair",
"city": "Austin",
"state": "TX",
"quantity": 8615,
"value": 16,
"month": 12,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 227,
"product": "Ladder",
"city": "Austin",
"state": "TX",
"quantity": 1346,
"value": 37,
"month": 6,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 228,
"product": "Ladder",
"city": "Austin",
"state": "NY",
"quantity": 4092,
"value": 19,
"month": 1,
"quarter": 1,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 229,
"product": "Chair",
"city": "London",
"state": "AZ",
"quantity": 7128,
"value": 42,
"month": 8,
"quarter": 1,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 230,
"product": "Spanner",
"city": "London",
"state": "AZ",
"quantity": 4972,
"value": 6,
"month": 1,
"quarter": 4,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 231,
"product": "Ladder",
"city": "San Francisco",
"state": "AZ",
"quantity": 3231,
"value": 26,
"month": 12,
"quarter": 1,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 232,
"product": "Chair",
"city": "Palo Alto",
"state": "CA",
"quantity": 4390,
"value": 4,
"month": 9,
"quarter": 1,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 233,
"product": "Chair",
"city": "Austin",
"state": "UK",
"quantity": 3050,
"value": 27,
"month": 7,
"quarter": 4,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 234,
"product": "Ladder",
"city": "San Francisco",
"state": "UK",
"quantity": 9311,
"value": 6,
"month": 6,
"quarter": 3,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 235,
"product": "Spanner",
"city": "London",
"state": "AZ",
"quantity": 337,
"value": 36,
"month": 7,
"quarter": 4,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 236,
"product": "Chair",
"city": "Austin",
"state": "CA",
"quantity": 87,
"value": 35,
"month": 1,
"quarter": 1,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 237,
"product": "Ladder",
"city": "Austin",
"state": "NY",
"quantity": 7283,
"value": 0,
"month": 1,
"quarter": 4,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 238,
"product": "Ladder",
"city": "London",
"state": "NY",
"quantity": 7449,
"value": 14,
"month": 2,
"quarter": 3,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 239,
"product": "Ladder",
"city": "London",
"state": "NY",
"quantity": 9624,
"value": 10,
"month": 1,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 240,
"product": "Chair",
"city": "London",
"state": "CA",
"quantity": 9158,
"value": 24,
"month": 11,
"quarter": 1,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 241,
"product": "Ladder",
"city": "Palo Alto",
"state": "CA",
"quantity": 1176,
"value": 25,
"month": 8,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 242,
"product": "Spanner",
"city": "Austin",
"state": "TX",
"quantity": 2276,
"value": 1,
"month": 2,
"quarter": 4,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 243,
"product": "Spanner",
"city": "London",
"state": "CA",
"quantity": 5299,
"value": 48,
"month": 5,
"quarter": 1,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 244,
"product": "Spanner",
"city": "Austin",
"state": "UK",
"quantity": 7536,
"value": 20,
"month": 4,
"quarter": 1,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 245,
"product": "Ladder",
"city": "London",
"state": "NY",
"quantity": 3553,
"value": 46,
"month": 11,
"quarter": 4,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 246,
"product": "Ladder",
"city": "London",
"state": "AZ",
"quantity": 652,
"value": 6,
"month": 11,
"quarter": 1,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 247,
"product": "Spanner",
"city": "San Francisco",
"state": "NY",
"quantity": 358,
"value": 38,
"month": 7,
"quarter": 1,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 248,
"product": "Spanner",
"city": "Palo Alto",
"state": "NY",
"quantity": 644,
"value": 39,
"month": 5,
"quarter": 1,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 249,
"product": "Ladder",
"city": "Palo Alto",
"state": "CA",
"quantity": 4795,
"value": 41,
"month": 4,
"quarter": 1,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 250,
"product": "Ladder",
"city": "Palo Alto",
"state": "AZ",
"quantity": 6547,
"value": 39,
"month": 12,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 251,
"product": "Chair",
"city": "London",
"state": "UK",
"quantity": 4127,
"value": 48,
"month": 12,
"quarter": 1,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 252,
"product": "Spanner",
"city": "Austin",
"state": "UK",
"quantity": 3746,
"value": 3,
"month": 1,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 253,
"product": "Spanner",
"city": "Palo Alto",
"state": "CA",
"quantity": 9600,
"value": 21,
"month": 11,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 254,
"product": "Chair",
"city": "Palo Alto",
"state": "AZ",
"quantity": 2411,
"value": 1,
"month": 6,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 255,
"product": "Ladder",
"city": "Austin",
"state": "UK",
"quantity": 1372,
"value": 17,
"month": 2,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 256,
"product": "Ladder",
"city": "London",
"state": "UK",
"quantity": 168,
"value": 36,
"month": 1,
"quarter": 4,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 257,
"product": "Spanner",
"city": "San Francisco",
"state": "UK",
"quantity": 6664,
"value": 0,
"month": 5,
"quarter": 1,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 258,
"product": "Ladder",
"city": "Austin",
"state": "UK",
"quantity": 3433,
"value": 14,
"month": 6,
"quarter": 1,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 259,
"product": "Ladder",
"city": "London",
"state": "TX",
"quantity": 4967,
"value": 36,
"month": 4,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 260,
"product": "Spanner",
"city": "Palo Alto",
"state": "UK",
"quantity": 2799,
"value": 10,
"month": 9,
"quarter": 1,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 261,
"product": "Chair",
"city": "San Francisco",
"state": "UK",
"quantity": 9237,
"value": 28,
"month": 11,
"quarter": 3,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 262,
"product": "Chair",
"city": "Austin",
"state": "NY",
"quantity": 4966,
"value": 14,
"month": 7,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 263,
"product": "Spanner",
"city": "London",
"state": "TX",
"quantity": 2006,
"value": 26,
"month": 10,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 264,
"product": "Chair",
"city": "London",
"state": "UK",
"quantity": 7374,
"value": 28,
"month": 2,
"quarter": 2,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 265,
"product": "Chair",
"city": "London",
"state": "UK",
"quantity": 2292,
"value": 35,
"month": 3,
"quarter": 4,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 266,
"product": "Chair",
"city": "San Francisco",
"state": "UK",
"quantity": 6722,
"value": 16,
"month": 11,
"quarter": 1,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 267,
"product": "Chair",
"city": "London",
"state": "TX",
"quantity": 4216,
"value": 17,
"month": 8,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 268,
"product": "Ladder",
"city": "Austin",
"state": "CA",
"quantity": 4386,
"value": 27,
"month": 3,
"quarter": 1,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 269,
"product": "Spanner",
"city": "Palo Alto",
"state": "AZ",
"quantity": 3873,
"value": 20,
"month": 9,
"quarter": 3,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 270,
"product": "Spanner",
"city": "Palo Alto",
"state": "NY",
"quantity": 1657,
"value": 31,
"month": 11,
"quarter": 2,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 271,
"product": "Spanner",
"city": "Palo Alto",
"state": "NY",
"quantity": 5737,
"value": 28,
"month": 8,
"quarter": 4,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 272,
"product": "Spanner",
"city": "Palo Alto",
"state": "CA",
"quantity": 3763,
"value": 43,
"month": 6,
"quarter": 4,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 273,
"product": "Ladder",
"city": "Palo Alto",
"state": "UK",
"quantity": 378,
"value": 6,
"month": 8,
"quarter": 3,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 274,
"product": "Chair",
"city": "San Francisco",
"state": "NY",
"quantity": 4061,
"value": 2,
"month": 8,
"quarter": 2,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 275,
"product": "Ladder",
"city": "Austin",
"state": "CA",
"quantity": 9520,
"value": 9,
"month": 12,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 276,
"product": "Chair",
"city": "Palo Alto",
"state": "TX",
"quantity": 8072,
"value": 3,
"month": 4,
"quarter": 4,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 277,
"product": "Ladder",
"city": "London",
"state": "CA",
"quantity": 3609,
"value": 21,
"month": 1,
"quarter": 1,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 278,
"product": "Spanner",
"city": "Palo Alto",
"state": "AZ",
"quantity": 3973,
"value": 3,
"month": 3,
"quarter": 2,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 279,
"product": "Spanner",
"city": "Palo Alto",
"state": "TX",
"quantity": 5312,
"value": 8,
"month": 12,
"quarter": 3,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 280,
"product": "Spanner",
"city": "London",
"state": "AZ",
"quantity": 7740,
"value": 39,
"month": 4,
"quarter": 2,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 281,
"product": "Spanner",
"city": "Austin",
"state": "NY",
"quantity": 8382,
"value": 25,
"month": 11,
"quarter": 2,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 282,
"product": "Chair",
"city": "San Francisco",
"state": "CA",
"quantity": 5993,
"value": 19,
"month": 3,
"quarter": 3,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 283,
"product": "Chair",
"city": "Palo Alto",
"state": "CA",
"quantity": 5439,
"value": 16,
"month": 6,
"quarter": 1,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 284,
"product": "Chair",
"city": "Palo Alto",
"state": "TX",
"quantity": 1335,
"value": 46,
"month": 11,
"quarter": 1,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 285,
"product": "Ladder",
"city": "Palo Alto",
"state": "CA",
"quantity": 1865,
"value": 18,
"month": 6,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 286,
"product": "Spanner",
"city": "London",
"state": "AZ",
"quantity": 9700,
"value": 48,
"month": 4,
"quarter": 1,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 287,
"product": "Ladder",
"city": "London",
"state": "AZ",
"quantity": 2797,
"value": 28,
"month": 10,
"quarter": 4,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 288,
"product": "Spanner",
"city": "Palo Alto",
"state": "CA",
"quantity": 8890,
"value": 0,
"month": 1,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 289,
"product": "Chair",
"city": "San Francisco",
"state": "TX",
"quantity": 4408,
"value": 10,
"month": 7,
"quarter": 3,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 290,
"product": "Ladder",
"city": "San Francisco",
"state": "UK",
"quantity": 9469,
"value": 29,
"month": 8,
"quarter": 3,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 291,
"product": "Spanner",
"city": "London",
"state": "UK",
"quantity": 3572,
"value": 29,
"month": 3,
"quarter": 3,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 292,
"product": "Chair",
"city": "Austin",
"state": "CA",
"quantity": 8199,
"value": 36,
"month": 10,
"quarter": 3,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 293,
"product": "Chair",
"city": "Austin",
"state": "NY",
"quantity": 1074,
"value": 12,
"month": 9,
"quarter": 3,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 294,
"product": "Ladder",
"city": "Austin",
"state": "CA",
"quantity": 4287,
"value": 38,
"month": 6,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 295,
"product": "Ladder",
"city": "London",
"state": "UK",
"quantity": 5912,
"value": 49,
"month": 10,
"quarter": 4,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 296,
"product": "Ladder",
"city": "Austin",
"state": "CA",
"quantity": 3314,
"value": 23,
"month": 5,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 297,
"product": "Spanner",
"city": "Palo Alto",
"state": "CA",
"quantity": 8244,
"value": 4,
"month": 4,
"quarter": 4,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 298,
"product": "Ladder",
"city": "Austin",
"state": "AZ",
"quantity": 6399,
"value": 36,
"month": 8,
"quarter": 4,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 299,
"product": "Chair",
"city": "San Francisco",
"state": "TX",
"quantity": 8688,
"value": 32,
"month": 9,
"quarter": 2,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 300,
"product": "Ladder",
"city": "London",
"state": "UK",
"quantity": 1787,
"value": 10,
"month": 2,
"quarter": 3,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 301,
"product": "Spanner",
"city": "Austin",
"state": "TX",
"quantity": 608,
"value": 6,
"month": 2,
"quarter": 4,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 302,
"product": "Chair",
"city": "San Francisco",
"state": "TX",
"quantity": 853,
"value": 18,
"month": 11,
"quarter": 3,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 303,
"product": "Chair",
"city": "Palo Alto",
"state": "UK",
"quantity": 5973,
"value": 36,
"month": 8,
"quarter": 4,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 304,
"product": "Ladder",
"city": "Austin",
"state": "NY",
"quantity": 7781,
"value": 0,
"month": 10,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 305,
"product": "Spanner",
"city": "San Francisco",
"state": "NY",
"quantity": 4069,
"value": 46,
"month": 6,
"quarter": 2,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 306,
"product": "Spanner",
"city": "London",
"state": "TX",
"quantity": 1384,
"value": 43,
"month": 9,
"quarter": 1,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 307,
"product": "Chair",
"city": "Austin",
"state": "TX",
"quantity": 3309,
"value": 48,
"month": 3,
"quarter": 4,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 308,
"product": "Chair",
"city": "San Francisco",
"state": "AZ",
"quantity": 7549,
"value": 44,
"month": 6,
"quarter": 2,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 309,
"product": "Ladder",
"city": "London",
"state": "NY",
"quantity": 7309,
"value": 44,
"month": 8,
"quarter": 3,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 310,
"product": "Spanner",
"city": "London",
"state": "TX",
"quantity": 2978,
"value": 44,
"month": 4,
"quarter": 3,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 311,
"product": "Spanner",
"city": "San Francisco",
"state": "NY",
"quantity": 3402,
"value": 24,
"month": 1,
"quarter": 2,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 312,
"product": "Chair",
"city": "Palo Alto",
"state": "CA",
"quantity": 6229,
"value": 32,
"month": 7,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 313,
"product": "Chair",
"city": "San Francisco",
"state": "AZ",
"quantity": 4203,
"value": 46,
"month": 12,
"quarter": 2,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 314,
"product": "Ladder",
"city": "Palo Alto",
"state": "TX",
"quantity": 9810,
"value": 28,
"month": 8,
"quarter": 3,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 315,
"product": "Chair",
"city": "Palo Alto",
"state": "CA",
"quantity": 5297,
"value": 17,
"month": 11,
"quarter": 3,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 316,
"product": "Chair",
"city": "Palo Alto",
"state": "AZ",
"quantity": 7730,
"value": 20,
"month": 1,
"quarter": 1,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 317,
"product": "Ladder",
"city": "Palo Alto",
"state": "TX",
"quantity": 919,
"value": 24,
"month": 6,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 318,
"product": "Ladder",
"city": "Austin",
"state": "AZ",
"quantity": 6634,
"value": 49,
"month": 1,
"quarter": 1,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 319,
"product": "Ladder",
"city": "San Francisco",
"state": "NY",
"quantity": 1990,
"value": 32,
"month": 12,
"quarter": 1,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 320,
"product": "Spanner",
"city": "San Francisco",
"state": "AZ",
"quantity": 577,
"value": 4,
"month": 4,
"quarter": 3,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 321,
"product": "Ladder",
"city": "Austin",
"state": "TX",
"quantity": 7506,
"value": 20,
"month": 1,
"quarter": 1,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 322,
"product": "Chair",
"city": "Austin",
"state": "CA",
"quantity": 3283,
"value": 10,
"month": 4,
"quarter": 2,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 323,
"product": "Spanner",
"city": "Palo Alto",
"state": "UK",
"quantity": 3925,
"value": 16,
"month": 4,
"quarter": 3,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 324,
"product": "Spanner",
"city": "Palo Alto",
"state": "UK",
"quantity": 713,
"value": 34,
"month": 3,
"quarter": 1,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 325,
"product": "Chair",
"city": "Palo Alto",
"state": "CA",
"quantity": 3662,
"value": 6,
"month": 4,
"quarter": 1,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 326,
"product": "Spanner",
"city": "San Francisco",
"state": "CA",
"quantity": 5309,
"value": 15,
"month": 12,
"quarter": 1,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 327,
"product": "Spanner",
"city": "Austin",
"state": "UK",
"quantity": 7939,
"value": 0,
"month": 9,
"quarter": 4,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 328,
"product": "Spanner",
"city": "Austin",
"state": "UK",
"quantity": 210,
"value": 38,
"month": 6,
"quarter": 3,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 329,
"product": "Chair",
"city": "Austin",
"state": "CA",
"quantity": 5997,
"value": 1,
"month": 6,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 330,
"product": "Chair",
"city": "Austin",
"state": "CA",
"quantity": 6156,
"value": 1,
"month": 3,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 331,
"product": "Spanner",
"city": "London",
"state": "AZ",
"quantity": 1846,
"value": 45,
"month": 4,
"quarter": 4,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 332,
"product": "Chair",
"city": "Austin",
"state": "CA",
"quantity": 2756,
"value": 14,
"month": 1,
"quarter": 1,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 333,
"product": "Ladder",
"city": "London",
"state": "CA",
"quantity": 185,
"value": 13,
"month": 4,
"quarter": 2,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 334,
"product": "Ladder",
"city": "London",
"state": "CA",
"quantity": 5470,
"value": 5,
"month": 12,
"quarter": 2,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 335,
"product": "Spanner",
"city": "London",
"state": "CA",
"quantity": 709,
"value": 30,
"month": 8,
"quarter": 1,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 336,
"product": "Chair",
"city": "San Francisco",
"state": "UK",
"quantity": 7905,
"value": 1,
"month": 6,
"quarter": 4,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 337,
"product": "Ladder",
"city": "London",
"state": "CA",
"quantity": 572,
"value": 30,
"month": 7,
"quarter": 1,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 338,
"product": "Spanner",
"city": "London",
"state": "NY",
"quantity": 2562,
"value": 7,
"month": 10,
"quarter": 2,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 339,
"product": "Ladder",
"city": "London",
"state": "TX",
"quantity": 7373,
"value": 8,
"month": 7,
"quarter": 1,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 340,
"product": "Chair",
"city": "Palo Alto",
"state": "TX",
"quantity": 120,
"value": 21,
"month": 9,
"quarter": 3,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 341,
"product": "Spanner",
"city": "London",
"state": "NY",
"quantity": 3865,
"value": 42,
"month": 12,
"quarter": 2,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 342,
"product": "Ladder",
"city": "London",
"state": "UK",
"quantity": 481,
"value": 30,
"month": 2,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 343,
"product": "Ladder",
"city": "Palo Alto",
"state": "TX",
"quantity": 9542,
"value": 11,
"month": 5,
"quarter": 1,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 344,
"product": "Spanner",
"city": "San Francisco",
"state": "NY",
"quantity": 1740,
"value": 10,
"month": 7,
"quarter": 4,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 345,
"product": "Chair",
"city": "Austin",
"state": "AZ",
"quantity": 457,
"value": 3,
"month": 4,
"quarter": 3,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 346,
"product": "Ladder",
"city": "San Francisco",
"state": "CA",
"quantity": 2543,
"value": 43,
"month": 10,
"quarter": 4,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 347,
"product": "Ladder",
"city": "Palo Alto",
"state": "UK",
"quantity": 1141,
"value": 37,
"month": 10,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 348,
"product": "Chair",
"city": "San Francisco",
"state": "UK",
"quantity": 4364,
"value": 29,
"month": 3,
"quarter": 2,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 349,
"product": "Ladder",
"city": "London",
"state": "TX",
"quantity": 5747,
"value": 21,
"month": 6,
"quarter": 2,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 350,
"product": "Ladder",
"city": "Palo Alto",
"state": "UK",
"quantity": 9148,
"value": 0,
"month": 6,
"quarter": 3,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 351,
"product": "Chair",
"city": "London",
"state": "CA",
"quantity": 1583,
"value": 12,
"month": 8,
"quarter": 2,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 352,
"product": "Ladder",
"city": "London",
"state": "AZ",
"quantity": 4923,
"value": 28,
"month": 4,
"quarter": 4,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 353,
"product": "Spanner",
"city": "London",
"state": "CA",
"quantity": 98,
"value": 0,
"month": 7,
"quarter": 1,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 354,
"product": "Spanner",
"city": "London",
"state": "TX",
"quantity": 7664,
"value": 43,
"month": 5,
"quarter": 4,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 355,
"product": "Chair",
"city": "San Francisco",
"state": "CA",
"quantity": 5634,
"value": 43,
"month": 11,
"quarter": 1,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 356,
"product": "Spanner",
"city": "London",
"state": "UK",
"quantity": 6393,
"value": 36,
"month": 2,
"quarter": 3,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 357,
"product": "Ladder",
"city": "Austin",
"state": "TX",
"quantity": 7922,
"value": 20,
"month": 9,
"quarter": 2,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 358,
"product": "Spanner",
"city": "San Francisco",
"state": "AZ",
"quantity": 6395,
"value": 4,
"month": 2,
"quarter": 1,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 359,
"product": "Ladder",
"city": "San Francisco",
"state": "CA",
"quantity": 9574,
"value": 44,
"month": 8,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 360,
"product": "Spanner",
"city": "London",
"state": "NY",
"quantity": 7240,
"value": 19,
"month": 11,
"quarter": 1,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 361,
"product": "Chair",
"city": "Austin",
"state": "NY",
"quantity": 9627,
"value": 45,
"month": 5,
"quarter": 1,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 362,
"product": "Spanner",
"city": "Palo Alto",
"state": "CA",
"quantity": 5408,
"value": 9,
"month": 11,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 363,
"product": "Chair",
"city": "San Francisco",
"state": "UK",
"quantity": 9739,
"value": 19,
"month": 3,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 364,
"product": "Spanner",
"city": "London",
"state": "NY",
"quantity": 3768,
"value": 23,
"month": 12,
"quarter": 1,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 365,
"product": "Chair",
"city": "London",
"state": "AZ",
"quantity": 8166,
"value": 0,
"month": 10,
"quarter": 3,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 366,
"product": "Spanner",
"city": "London",
"state": "TX",
"quantity": 1783,
"value": 31,
"month": 12,
"quarter": 1,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 367,
"product": "Chair",
"city": "San Francisco",
"state": "AZ",
"quantity": 6331,
"value": 31,
"month": 6,
"quarter": 3,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 368,
"product": "Ladder",
"city": "Austin",
"state": "AZ",
"quantity": 7571,
"value": 36,
"month": 7,
"quarter": 3,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 369,
"product": "Ladder",
"city": "Palo Alto",
"state": "AZ",
"quantity": 8248,
"value": 22,
"month": 5,
"quarter": 4,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 370,
"product": "Ladder",
"city": "London",
"state": "CA",
"quantity": 1794,
"value": 25,
"month": 3,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 371,
"product": "Spanner",
"city": "London",
"state": "UK",
"quantity": 9811,
"value": 5,
"month": 4,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 372,
"product": "Spanner",
"city": "London",
"state": "AZ",
"quantity": 687,
"value": 11,
"month": 9,
"quarter": 2,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 373,
"product": "Ladder",
"city": "San Francisco",
"state": "CA",
"quantity": 2799,
"value": 46,
"month": 6,
"quarter": 1,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 374,
"product": "Spanner",
"city": "Austin",
"state": "CA",
"quantity": 687,
"value": 24,
"month": 2,
"quarter": 2,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 375,
"product": "Chair",
"city": "Austin",
"state": "TX",
"quantity": 3792,
"value": 20,
"month": 12,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 376,
"product": "Ladder",
"city": "San Francisco",
"state": "AZ",
"quantity": 2759,
"value": 16,
"month": 9,
"quarter": 4,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 377,
"product": "Ladder",
"city": "Austin",
"state": "TX",
"quantity": 4662,
"value": 3,
"month": 9,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 378,
"product": "Chair",
"city": "Austin",
"state": "TX",
"quantity": 2496,
"value": 25,
"month": 2,
"quarter": 3,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 379,
"product": "Chair",
"city": "San Francisco",
"state": "CA",
"quantity": 5671,
"value": 6,
"month": 7,
"quarter": 2,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 380,
"product": "Chair",
"city": "Palo Alto",
"state": "NY",
"quantity": 3895,
"value": 27,
"month": 4,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 381,
"product": "Ladder",
"city": "Austin",
"state": "AZ",
"quantity": 2933,
"value": 20,
"month": 7,
"quarter": 3,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 382,
"product": "Ladder",
"city": "Palo Alto",
"state": "TX",
"quantity": 3444,
"value": 2,
"month": 12,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 383,
"product": "Ladder",
"city": "Palo Alto",
"state": "UK",
"quantity": 5372,
"value": 1,
"month": 7,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 384,
"product": "Ladder",
"city": "Austin",
"state": "NY",
"quantity": 6789,
"value": 6,
"month": 1,
"quarter": 1,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 385,
"product": "Spanner",
"city": "Austin",
"state": "CA",
"quantity": 4717,
"value": 36,
"month": 5,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 386,
"product": "Spanner",
"city": "Palo Alto",
"state": "UK",
"quantity": 9629,
"value": 25,
"month": 6,
"quarter": 2,
"year": 2010,
"person": "Jamie Avins"
},
{
"id": 387,
"product": "Ladder",
"city": "Palo Alto",
"state": "AZ",
"quantity": 3693,
"value": 25,
"month": 5,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 388,
"product": "Ladder",
"city": "Palo Alto",
"state": "UK",
"quantity": 6814,
"value": 4,
"month": 6,
"quarter": 1,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 389,
"product": "Ladder",
"city": "London",
"state": "TX",
"quantity": 3462,
"value": 29,
"month": 11,
"quarter": 3,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 390,
"product": "Chair",
"city": "San Francisco",
"state": "NY",
"quantity": 7821,
"value": 29,
"month": 12,
"quarter": 3,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 391,
"product": "Spanner",
"city": "Austin",
"state": "TX",
"quantity": 5040,
"value": 39,
"month": 2,
"quarter": 3,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 392,
"product": "Ladder",
"city": "Palo Alto",
"state": "UK",
"quantity": 1831,
"value": 8,
"month": 2,
"quarter": 4,
"year": 2010,
"person": "Abe Elias"
},
{
"id": 393,
"product": "Spanner",
"city": "London",
"state": "AZ",
"quantity": 9555,
"value": 4,
"month": 4,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 394,
"product": "Chair",
"city": "San Francisco",
"state": "TX",
"quantity": 8308,
"value": 28,
"month": 12,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 395,
"product": "Chair",
"city": "Austin",
"state": "AZ",
"quantity": 6514,
"value": 49,
"month": 6,
"quarter": 4,
"year": 2010,
"person": "Ed Spencer"
},
{
"id": 396,
"product": "Spanner",
"city": "San Francisco",
"state": "AZ",
"quantity": 5418,
"value": 28,
"month": 9,
"quarter": 4,
"year": 2009,
"person": "Abe Elias"
},
{
"id": 397,
"product": "Chair",
"city": "Palo Alto",
"state": "UK",
"quantity": 4975,
"value": 23,
"month": 10,
"quarter": 3,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 398,
"product": "Ladder",
"city": "San Francisco",
"state": "AZ",
"quantity": 5972,
"value": 4,
"month": 5,
"quarter": 1,
"year": 2009,
"person": "Jamie Avins"
},
{
"id": 399,
"product": "Ladder",
"city": "Palo Alto",
"state": "UK",
"quantity": 2435,
"value": 3,
"month": 4,
"quarter": 4,
"year": 2009,
"person": "Ed Spencer"
},
{
"id": 400,
"product": "Ladder",
"city": "Palo Alto",
"state": "AZ",
"quantity": 7365,
"value": 21,
"month": 3,
"quarter": 2,
"year": 2009,
"person": "Jamie Avins"
}]
}
相关推荐
Extjs 中想改变grid 行高，如果只是简单的设置了height的值是可以实现grid 的行高，但是如果使用了插件：rowexpander ，最出现新的问题。 感兴趣的朋友可以试试的。 此文档可以解决你的烦恼，为了找到资源下载，...
ExtJS grid过滤操作，可以动态操作本地的store更改筛选的内容
Extjs动态Grid的生成 htm
Ext各种组件的使用实例，Extjs tree+grid+form+panel 使用实例
基于Extjs4官方的例子，做了一个关于MVC和Grid增删改的小例子
extjs grid示例代码extjs grid示例代码extjs grid示例代码extjs grid示例代码
这是利用sencha cmd 生成的GridFilterDemo工程中的app和build文件夹，其余文件过大并且与主题无关,因此未包含。具体方法，请参看我的博客: 《Extjs4.2 Grid Filter Feature 表格过滤特性》
title的header表头名、width宽度、dataIndex映射名都可以根据外部定义的xml进行读取，便于将ExtJs的Grid封装
EXTJS4 GRID 表格 分页 编辑 添加判断 颜色判断 分组 等示例
自己写的一个Extjs Grid2Grid拖拽
extjs4打印grid插件，官网上的一个例子程序，有需要的人可以下载来看看。
ExtJs 4.0 Grid 单元格合并控件封装
ExtJs Grid是否选择行，是：返回选择行record;否：返回false
extjs4 grid 包括form js代码
Extjs4下拉菜单中用Grid显示，有单选，和多选两个控件，完美通用代码控件，绝对让你好用，值得收藏^-^
EXTJS grid导出EXCEL文件，源码可以直接导入MYECLIPSE使用，EXTJS版本3.2.0
使用ExtJs相关的控件类自己实现的一个ExtJs的Grid列表的导出功能，可以导出列表的相关样式等
Extjs grid 中文排序问题修正，其实很简单，请自己看源代码
这是一个简单的在extjs下的grid转化到Excel，里面代码简单易懂，在包里面还集成了复杂的js转化函数，不过本人没有用它来进行转化！ 注：在用EXTJS的导出Excel技术中，一定要注意分页的问题
Extjs4 grid 导出为Excel 下载后放在网站(不放在网站中导出按钮不能会点击无响应,因为这里调用了swf文件)里可直接运行index.html测试 <link href='...