`

ExtJs中Pivot Grid在统计时的一般使用

 
阅读更多

 

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"
    }]
}

 

 

  • 大小: 19.1 KB
分享到:
评论

相关推荐

    Extjs4 grid使用例子

    在给定的"Extjs4 grid使用例子"中,我们可以深入理解如何在MVC架构下有效地利用ExtJS4的Grid组件。Grid组件是ExtJS中的核心部分,它提供了一个灵活的、可定制的数据展示网格,通常用于显示和操作大量数据。 1. **...

    extjs中设置grid默认行高及换行

    Extjs 中想改变grid 行高,如果只是简单的设置了height的值是可以实现grid 的行高,但是如果使用了插件:rowexpander ,最出现新的问题。 感兴趣的朋友可以试试的。 此文档可以解决你的烦恼,为了找到资源下载,...

    ExtJS grid过滤操作

    在myapp4项目中,你可能会找到相关的代码示例,展示了如何在实际应用中配置和使用ExtJS Grid的过滤功能。通过阅读和理解这些代码,你可以更好地理解和应用上述理论知识。 总结来说,ExtJS Grid的过滤操作提供了...

    ExtJs动态grid的生成

    本文将深入探讨如何在ExtJS中动态生成Grid,这是一个非常实用的功能,可以适应不断变化的数据需求和用户交互。我们首先从标题"ExtJs动态grid的生成"开始,了解动态生成Grid的基本概念和实现方法。 动态生成Grid意味...

    extjs4打印grid插件

    为了在项目中使用这个插件,首先需要将相关文件引入到HTML页面,然后在Grid配置中启用打印插件,并设置相应的参数。在用户触发打印操作时,调用插件提供的方法,如`print()`,完成打印过程。 总的来说,"extjs4打印...

    Extjs grid 中文排序问题修正

    在EXTJS开发中,我们经常会遇到使用Grid组件展示数据的情况,特别是当数据包含中文字符时,可能会遇到排序问题。EXTJS Grid默认的排序机制对于英文字符处理得较好,但对于中文字符,由于编码和比较规则的不同,可能...

    extjs grid数据导出excel文件

    具体实现时,开发者可能会在EXTJS的事件处理器中添加导出功能,例如在Grid的工具栏上添加一个“导出”按钮,当点击该按钮时触发数据导出的函数。这个函数会按照上述步骤操作,最终生成一个可供下载的Excel文件。 在...

    ExtJs grid多选时获取选中的所有值

    因此,掌握如何在ExtJs Grid中实现多选功能以及如何获取已选中的所有值是非常重要的。 #### 二、实现多选功能 在ExtJs中,实现Grid的多选功能主要通过`CheckboxSelectionModel`来完成。下面将详细介绍如何设置并...

    EXTJS grid导出EXCEL文件

    4. **源码使用**:提到“源码可以直接导入MYECLIPSE使用”,这意味着提供的是一个实际的代码示例,你可以直接在MyEclipse(一个流行的Java集成开发环境)中打开并运行,以便学习和理解如何实现EXTJS Grid到Excel的...

    Extjs动态Grid的生成 htm

    Extjs动态Grid的生成 htm

    ExtJs Grid选择行

    在ExtJs框架中,Grid组件是一种非常常用的展示数据表格的方式,它提供了丰富的功能,包括数据的排序、分页、过滤以及行选择等。在实际应用中,经常需要根据用户交互来判断Grid中的行是否被选中,以便进行下一步的...

    Extjs tree+grid+form+panel 使用实例

    Ext各种组件的使用实例,Extjs tree+grid+form+panel 使用实例

    Extjs Grid2Grid拖拽

    在ExtJS中,Grid组件是一个非常重要的部分,它用于显示和操作大量的表格数据。"Grid2Grid拖拽"功能是指在两个ExtJS Grid之间通过鼠标拖放操作来移动或复制行数据。这种功能在数据管理、比较和操作场景中非常实用。 ...

    Extjs动态GRID

    在EXTJS中,动态GRID指的是可以实时调整列宽、列数甚至列结构的网格视图,以适应不同的数据需求和用户界面变化。 1. 动态列创建与删除: EXTJS的Grid Panel支持在运行时动态添加或移除列。这可以通过调用`columns....

    ExtJS4.0 分享GridHeaderFilters插件

    在使用GridHeaderFilters之前,你需要确保已经正确地安装了ExtJS 4.0库,并在项目中引入了所需的文件,通常包括`ext-all.js`(或`ext-debug.js`用于开发环境)以及`filtergrid.js`(或相关源码文件),这个文件包含...

    Extjs4.2 Grid filter Demo 表格过滤实验

    这是利用sencha cmd 生成的GridFilterDemo工程中的app和build文件夹,其余文件过大并且与主题无关,因此未包含。具体方法,请参看我的博客: 《Extjs4.2 Grid Filter Feature 表格过滤特性》

    Extjs Grid 中的 ToolTip效果

    可以修改`Ext.tip.ToolTip`的样式,或者在GridTip中使用`headerStyle`和`bodyStyle`来分别设置头部和主体的样式。 通过以上方法,我们可以在EXTJS Grid中实现各种丰富的Tooltip效果,提供更佳的数据展示体验。无论...

    extjs4 ComboBox 点击下拉框 出现grid效果

    在EXTJS4中,ComboBox是一个常用的组件,它用于创建下拉选择框,通常用于输入框的辅助选择。这个组件提供了一种用户友好的方式来从一组预定义的选项中进行选择。然而,根据你的标题和描述,你似乎遇到了一个特别的...

    Extjs4下拉菜单ComboBox中用Grid显示通用控件

    在EXTJS4中,`ComboBox` 是一个非常常用的组件,它提供了一个下拉选择框的功能。在某些场景下,我们可能需要在下拉菜单中展示更丰富的信息,比如表格数据,这时就可以使用 `GridComboBox`。`GridComboBox` 结合了 `...

    ExtJS 使用grid显示数据

    在ExtJS中,Grid Panel是一种数据驱动的组件,它允许开发者以表格的形式展示大量数据,并且支持分页、排序、过滤、编辑等功能。要创建一个Grid,首先需要定义数据模型(Model),它描述了数据的结构,包括字段名和...

Global site tag (gtag.js) - Google Analytics