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"
}]
}
相关推荐
在给定的"Extjs4 grid使用例子"中，我们可以深入理解如何在MVC架构下有效地利用ExtJS4的Grid组件。Grid组件是ExtJS中的核心部分，它提供了一个灵活的、可定制的数据展示网格，通常用于显示和操作大量数据。 1. **...
Extjs 中想改变grid 行高，如果只是简单的设置了height的值是可以实现grid 的行高，但是如果使用了插件：rowexpander ，最出现新的问题。 感兴趣的朋友可以试试的。 此文档可以解决你的烦恼，为了找到资源下载，...
在myapp4项目中，你可能会找到相关的代码示例，展示了如何在实际应用中配置和使用ExtJS Grid的过滤功能。通过阅读和理解这些代码，你可以更好地理解和应用上述理论知识。 总结来说，ExtJS Grid的过滤操作提供了...
本文将深入探讨如何在ExtJS中动态生成Grid，这是一个非常实用的功能，可以适应不断变化的数据需求和用户交互。我们首先从标题"ExtJs动态grid的生成"开始，了解动态生成Grid的基本概念和实现方法。 动态生成Grid意味...
为了在项目中使用这个插件，首先需要将相关文件引入到HTML页面，然后在Grid配置中启用打印插件，并设置相应的参数。在用户触发打印操作时，调用插件提供的方法，如`print()`，完成打印过程。 总的来说，"extjs4打印...
在EXTJS开发中，我们经常会遇到使用Grid组件展示数据的情况，特别是当数据包含中文字符时，可能会遇到排序问题。EXTJS Grid默认的排序机制对于英文字符处理得较好，但对于中文字符，由于编码和比较规则的不同，可能...
具体实现时，开发者可能会在EXTJS的事件处理器中添加导出功能，例如在Grid的工具栏上添加一个“导出”按钮，当点击该按钮时触发数据导出的函数。这个函数会按照上述步骤操作，最终生成一个可供下载的Excel文件。 在...
因此，掌握如何在ExtJs Grid中实现多选功能以及如何获取已选中的所有值是非常重要的。 #### 二、实现多选功能 在ExtJs中，实现Grid的多选功能主要通过`CheckboxSelectionModel`来完成。下面将详细介绍如何设置并...
4. **源码使用**：提到“源码可以直接导入MYECLIPSE使用”，这意味着提供的是一个实际的代码示例，你可以直接在MyEclipse（一个流行的Java集成开发环境）中打开并运行，以便学习和理解如何实现EXTJS Grid到Excel的...
Extjs动态Grid的生成 htm
在ExtJs框架中，Grid组件是一种非常常用的展示数据表格的方式，它提供了丰富的功能，包括数据的排序、分页、过滤以及行选择等。在实际应用中，经常需要根据用户交互来判断Grid中的行是否被选中，以便进行下一步的...
Ext各种组件的使用实例，Extjs tree+grid+form+panel 使用实例
在ExtJS中，Grid组件是一个非常重要的部分，它用于显示和操作大量的表格数据。"Grid2Grid拖拽"功能是指在两个ExtJS Grid之间通过鼠标拖放操作来移动或复制行数据。这种功能在数据管理、比较和操作场景中非常实用。 ...
在EXTJS中，动态GRID指的是可以实时调整列宽、列数甚至列结构的网格视图，以适应不同的数据需求和用户界面变化。 1. 动态列创建与删除： EXTJS的Grid Panel支持在运行时动态添加或移除列。这可以通过调用`columns....
在使用GridHeaderFilters之前，你需要确保已经正确地安装了ExtJS 4.0库，并在项目中引入了所需的文件，通常包括`ext-all.js`（或`ext-debug.js`用于开发环境）以及`filtergrid.js`（或相关源码文件），这个文件包含...
这是利用sencha cmd 生成的GridFilterDemo工程中的app和build文件夹，其余文件过大并且与主题无关,因此未包含。具体方法，请参看我的博客: 《Extjs4.2 Grid Filter Feature 表格过滤特性》
可以修改`Ext.tip.ToolTip`的样式，或者在GridTip中使用`headerStyle`和`bodyStyle`来分别设置头部和主体的样式。 通过以上方法，我们可以在EXTJS Grid中实现各种丰富的Tooltip效果，提供更佳的数据展示体验。无论...
在EXTJS4中，ComboBox是一个常用的组件，它用于创建下拉选择框，通常用于输入框的辅助选择。这个组件提供了一种用户友好的方式来从一组预定义的选项中进行选择。然而，根据你的标题和描述，你似乎遇到了一个特别的...
在EXTJS4中，`ComboBox` 是一个非常常用的组件，它提供了一个下拉选择框的功能。在某些场景下，我们可能需要在下拉菜单中展示更丰富的信息，比如表格数据，这时就可以使用 `GridComboBox`。`GridComboBox` 结合了 `...
在ExtJS中，Grid Panel是一种数据驱动的组件，它允许开发者以表格的形式展示大量数据，并且支持分页、排序、过滤、编辑等功能。要创建一个Grid，首先需要定义数据模型（Model），它描述了数据的结构，包括字段名和...