Your search did not match any results.

Pivot Grid - Simple Array

The PivotGrid component can display data from an array of objects. Use the dataSource property to bind the PivotGrid to data. This property accepts a PivotGridDataSource instance or its configuration object. Assign your array to the store property of PivotGridDataSource.

To display data in the PivotGrid, assign an array to the fields[] property. Each object in this array configures a single pivot grid field. Assign a field name to the dataField property to populate the pivot grid field with data.

Backend API
<div class="long-title"><h3>Sales Amount by Region</h3></div> @(Html.DevExtreme().PivotGrid() .ID("sales") .AllowSortingBySummary(true) .AllowSorting(true) .AllowFiltering(true) .AllowExpandAll(true) .Height(440) .ShowBorders(true) .FieldChooser(c => c.Enabled(false)) .DataSource(d => d .Store(new JS("sales")) .Fields(fields => { fields.Add() .Caption("Region") .Width(120) .DataField("Region") .Area(PivotGridArea.Row); fields.Add() .Caption("City") .Width(150) .DataField("City") .Area(PivotGridArea.Row) .Selector(@<text> function(data) { return data.City + " (" + data.Country + ")"; } </text>); fields.Add() .DataField("Date") .DataType(PivotGridDataType.Date) .Area(PivotGridArea.Column); fields.Add() .Caption("Sales") .DataField("Amount") .DataType(PivotGridDataType.Number) .SummaryType(SummaryType.Sum) .Format(Format.Currency) .Area(PivotGridArea.Data); }) ) ) <script src="~/Scripts/data/sales.js"></script>
using DevExtreme.MVC.Demos.Models.SampleData; using Newtonsoft.Json; using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; namespace DevExtreme.MVC.Demos.Controllers { public class PivotGridController : Controller { public ActionResult SimpleArray() { return View(); } } }
var sales = [{ "OrderId": 1, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 1740, "Date": "2013/01/06" }, { "OrderId": 2, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 850, "Date": "2013/01/13" }, { "OrderId": 3, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 2235, "Date": "2013/01/07" }, { "OrderId": 4, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 1965, "Date": "2013/01/03" }, { "OrderId": 5, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 880, "Date": "2013/01/10" }, { "OrderId": 6, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 5260, "Date": "2013/01/17" }, { "OrderId": 7, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 2790, "Date": "2013/01/21" }, { "OrderId": 8, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 3140, "Date": "2013/01/01" }, { "OrderId": 9, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 6175, "Date": "2013/01/24" }, { "OrderId": 10, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 4575, "Date": "2013/01/11" }, { "OrderId": 11, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 3680, "Date": "2013/01/12" }, { "OrderId": 12, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 2260, "Date": "2013/01/01" }, { "OrderId": 13, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 2910, "Date": "2013/01/26" }, { "OrderId": 14, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 8400, "Date": "2013/01/05" }, { "OrderId": 15, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 1325, "Date": "2013/01/14" }, { "OrderId": 16, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 3920, "Date": "2013/01/05" }, { "OrderId": 17, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 2220, "Date": "2013/01/15" }, { "OrderId": 18, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 940, "Date": "2013/01/01" }, { "OrderId": 19, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 1630, "Date": "2013/01/10" }, { "OrderId": 20, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 2910, "Date": "2013/01/23" }, { "OrderId": 21, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 2600, "Date": "2013/01/14" }, { "OrderId": 22, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 4340, "Date": "2013/01/26" }, { "OrderId": 23, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 6650, "Date": "2013/01/24" }, { "OrderId": 24, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 490, "Date": "2013/01/22" }, { "OrderId": 25, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 3390, "Date": "2013/01/25" }, { "OrderId": 26, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 5160, "Date": "2013/02/20" }, { "OrderId": 27, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 5750, "Date": "2013/02/12" }, { "OrderId": 28, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 2805, "Date": "2013/02/13" }, { "OrderId": 29, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 2505, "Date": "2013/02/09" }, { "OrderId": 30, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 930, "Date": "2013/02/04" }, { "OrderId": 31, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 1240, "Date": "2013/02/03" }, { "OrderId": 32, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 315, "Date": "2013/02/04" }, { "OrderId": 33, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 2870, "Date": "2013/02/18" }, { "OrderId": 34, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 5150, "Date": "2013/02/18" }, { "OrderId": 35, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 2725, "Date": "2013/02/20" }, { "OrderId": 36, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 2840, "Date": "2013/02/04" }, { "OrderId": 37, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 5840, "Date": "2013/02/13" }, { "OrderId": 38, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 6750, "Date": "2013/02/11" }, { "OrderId": 39, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 1200, "Date": "2013/02/03" }, { "OrderId": 40, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 4550, "Date": "2013/02/08" }, { "OrderId": 41, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 6040, "Date": "2013/02/17" }, { "OrderId": 42, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 2205, "Date": "2013/02/08" }, { "OrderId": 43, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 990, "Date": "2013/02/20" }, { "OrderId": 44, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 700, "Date": "2013/02/11" }, { "OrderId": 45, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 2325, "Date": "2013/02/15" }, { "OrderId": 46, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 930, "Date": "2013/02/21" }, { "OrderId": 47, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 1560, "Date": "2013/02/04" }, { "OrderId": 48, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 1740, "Date": "2013/03/04" }, { "OrderId": 49, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 3575, "Date": "2013/03/20" }, { "OrderId": 50, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 4500, "Date": "2013/03/04" }, { "OrderId": 51, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 1605, "Date": "2013/03/17" }, { "OrderId": 52, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 800, "Date": "2013/03/21" }, { "OrderId": 53, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 640, "Date": "2013/03/08" }, { "OrderId": 54, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 735, "Date": "2013/03/19" }, { "OrderId": 55, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 2520, "Date": "2013/03/20" }, { "OrderId": 56, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 6675, "Date": "2013/03/18" }, { "OrderId": 57, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 3625, "Date": "2013/03/25" }, { "OrderId": 58, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 1200, "Date": "2013/03/07" }, { "OrderId": 59, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 2000, "Date": "2013/03/07" }, { "OrderId": 60, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 1410, "Date": "2013/03/10" }, { "OrderId": 61, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 2700, "Date": "2013/03/19" }, { "OrderId": 62, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 5950, "Date": "2013/03/24" }, { "OrderId": 63, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 5120, "Date": "2013/03/08" }, { "OrderId": 64, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 1980, "Date": "2013/03/17" }, { "OrderId": 65, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 1110, "Date": "2013/03/08" }, { "OrderId": 66, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 980, "Date": "2013/03/21" }, { "OrderId": 67, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 5460, "Date": "2013/03/19" }, { "OrderId": 68, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 3800, "Date": "2013/03/12" }, { "OrderId": 69, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 2610, "Date": "2013/03/04" }, { "OrderId": 70, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 3080, "Date": "2013/03/22" }, { "OrderId": 71, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 2010, "Date": "2013/03/23" }, { "OrderId": 72, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 1200, "Date": "2013/03/04" }, { "OrderId": 73, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 7680, "Date": "2013/04/15" }, { "OrderId": 74, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 1325, "Date": "2013/04/07" }, { "OrderId": 75, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 2835, "Date": "2013/04/10" }, { "OrderId": 76, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 3660, "Date": "2013/04/10" }, { "OrderId": 77, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 390, "Date": "2013/04/12" }, { "OrderId": 78, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 4420, "Date": "2013/04/08" }, { "OrderId": 79, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 1755, "Date": "2013/04/13" }, { "OrderId": 80, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 2580, "Date": "2013/04/15" }, { "OrderId": 81, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 850, "Date": "2013/04/01" }, { "OrderId": 82, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 2825, "Date": "2013/04/10" }, { "OrderId": 83, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 540, "Date": "2013/04/06" }, { "OrderId": 84, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 1520, "Date": "2013/04/08" }, { "OrderId": 85, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 8760, "Date": "2013/04/26" }, { "OrderId": 86, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 1110, "Date": "2013/04/16" }, { "OrderId": 87, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 6850, "Date": "2013/04/19" }, { "OrderId": 88, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 1940, "Date": "2013/04/23" }, { "OrderId": 89, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 1980, "Date": "2013/04/21" }, { "OrderId": 90, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 3090, "Date": "2013/04/03" }, { "OrderId": 91, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 1640, "Date": "2013/04/24" }, { "OrderId": 92, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 3585, "Date": "2013/04/01" }, { "OrderId": 93, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 1770, "Date": "2013/04/01" }, { "OrderId": 94, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 4005, "Date": "2013/04/04" }, { "OrderId": 95, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 2870, "Date": "2013/04/02" }, { "OrderId": 96, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 960, "Date": "2013/04/20" }, { "OrderId": 97, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 8640, "Date": "2013/05/14" }, { "OrderId": 98, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 5450, "Date": "2013/05/24" }, { "OrderId": 99, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 2535, "Date": "2013/05/07" }, { "OrderId": 100, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 1155, "Date": "2013/05/20" }, { "OrderId": 101, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 3140, "Date": "2013/05/18" }, { "OrderId": 102, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 2260, "Date": "2013/05/19" }, { "OrderId": 103, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 1215, "Date": "2013/05/23" }, { "OrderId": 104, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 1210, "Date": "2013/05/08" }, { "OrderId": 105, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 875, "Date": "2013/05/25" }, { "OrderId": 106, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 5400, "Date": "2013/05/03" }, { "OrderId": 107, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 5940, "Date": "2013/05/25" }, { "OrderId": 108, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 4700, "Date": "2013/05/03" }, { "OrderId": 109, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 5520, "Date": "2013/05/12" }, { "OrderId": 110, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 9210, "Date": "2013/05/22" }, { "OrderId": 111, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 7950, "Date": "2013/05/12" }, { "OrderId": 112, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 3740, "Date": "2013/05/24" }, { "OrderId": 113, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 990, "Date": "2013/05/02" }, { "OrderId": 114, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 3190, "Date": "2013/05/03" }, { "OrderId": 115, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 2430, "Date": "2013/05/11" }, { "OrderId": 116, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 7380, "Date": "2013/06/15" }, { "OrderId": 117, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 4475, "Date": "2013/06/08" }, { "OrderId": 118, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 1290, "Date": "2013/06/10" }, { "OrderId": 119, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 2250, "Date": "2013/06/10" }, { "OrderId": 120, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 350, "Date": "2013/06/22" }, { "OrderId": 121, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 5480, "Date": "2013/06/24" }, { "OrderId": 122, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 2355, "Date": "2013/06/10" }, { "OrderId": 123, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 1960, "Date": "2013/06/23" }, { "OrderId": 124, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 4125, "Date": "2013/06/06" }, { "OrderId": 125, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 7925, "Date": "2013/06/12" }, { "OrderId": 126, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 1120, "Date": "2013/06/22" }, { "OrderId": 127, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 5100, "Date": "2013/06/01" }, { "OrderId": 128, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 1500, "Date": "2013/06/25" }, { "OrderId": 129, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 5130, "Date": "2013/06/10" }, { "OrderId": 130, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 2475, "Date": "2013/06/10" }, { "OrderId": 131, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 2100, "Date": "2013/06/06" }, { "OrderId": 132, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 3570, "Date": "2013/06/10" }, { "OrderId": 133, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 550, "Date": "2013/06/02" }, { "OrderId": 134, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 2850, "Date": "2013/06/26" }, { "OrderId": 135, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 4280, "Date": "2013/06/19" }, { "OrderId": 136, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 1460, "Date": "2013/06/17" }, { "OrderId": 137, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 960, "Date": "2013/06/17" }, { "OrderId": 138, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 1520, "Date": "2013/06/03" }, { "OrderId": 139, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 6750, "Date": "2013/06/21" }, { "OrderId": 140, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 7260, "Date": "2013/07/14" }, { "OrderId": 141, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 2450, "Date": "2013/07/11" }, { "OrderId": 142, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 3540, "Date": "2013/07/02" }, { "OrderId": 143, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 1950, "Date": "2013/07/03" }, { "OrderId": 144, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 360, "Date": "2013/07/07" }, { "OrderId": 145, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 4500, "Date": "2013/07/03" }, { "OrderId": 146, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 4575, "Date": "2013/07/21" }, { "OrderId": 147, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 2310, "Date": "2013/07/18" }, { "OrderId": 148, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 7500, "Date": "2013/07/04" }, { "OrderId": 149, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 3575, "Date": "2013/07/23" }, { "OrderId": 150, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 760, "Date": "2013/07/01" }, { "OrderId": 151, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 2400, "Date": "2013/07/11" }, { "OrderId": 152, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 3330, "Date": "2013/07/04" }, { "OrderId": 153, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 3480, "Date": "2013/07/23" }, { "OrderId": 154, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 4875, "Date": "2013/07/11" }, { "OrderId": 155, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 4980, "Date": "2013/07/19" }, { "OrderId": 156, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 2580, "Date": "2013/07/04" }, { "OrderId": 157, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 2650, "Date": "2013/07/16" }, { "OrderId": 158, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 1190, "Date": "2013/07/02" }, { "OrderId": 159, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 960, "Date": "2013/07/26" }, { "OrderId": 160, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 3600, "Date": "2013/08/08" }, { "OrderId": 161, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 2250, "Date": "2013/08/01" }, { "OrderId": 162, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 1275, "Date": "2013/08/02" }, { "OrderId": 163, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 3885, "Date": "2013/08/14" }, { "OrderId": 164, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 1900, "Date": "2013/08/05" }, { "OrderId": 165, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 2300, "Date": "2013/08/09" }, { "OrderId": 166, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 2895, "Date": "2013/08/15" }, { "OrderId": 167, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 350, "Date": "2013/08/20" }, { "OrderId": 168, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 4200, "Date": "2013/08/22" }, { "OrderId": 169, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 7175, "Date": "2013/08/14" }, { "OrderId": 170, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 4420, "Date": "2013/08/24" }, { "OrderId": 171, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 5200, "Date": "2013/08/21" }, { "OrderId": 172, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 7920, "Date": "2013/08/17" }, { "OrderId": 173, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 6990, "Date": "2013/08/22" }, { "OrderId": 174, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 2125, "Date": "2013/08/05" }, { "OrderId": 175, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 2220, "Date": "2013/08/16" }, { "OrderId": 176, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 1575, "Date": "2013/08/23" }, { "OrderId": 177, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 1880, "Date": "2013/08/12" }, { "OrderId": 178, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 710, "Date": "2013/08/25" }, { "OrderId": 179, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 390, "Date": "2013/08/20" }, { "OrderId": 180, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 4635, "Date": "2013/08/04" }, { "OrderId": 181, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 4350, "Date": "2013/08/19" }, { "OrderId": 182, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 6020, "Date": "2013/08/02" }, { "OrderId": 183, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 3660, "Date": "2013/08/19" }, { "OrderId": 184, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 4525, "Date": "2013/08/24" }, { "OrderId": 185, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 4410, "Date": "2013/09/12" }, { "OrderId": 186, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 1725, "Date": "2013/09/07" }, { "OrderId": 187, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 2715, "Date": "2013/09/14" }, { "OrderId": 188, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 2820, "Date": "2013/09/08" }, { "OrderId": 189, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 2310, "Date": "2013/09/12" }, { "OrderId": 190, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 780, "Date": "2013/09/08" }, { "OrderId": 191, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 2370, "Date": "2013/09/19" }, { "OrderId": 192, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 1410, "Date": "2013/09/09" }, { "OrderId": 193, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 1825, "Date": "2013/09/23" }, { "OrderId": 194, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 4075, "Date": "2013/09/06" }, { "OrderId": 195, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 1020, "Date": "2013/09/04" }, { "OrderId": 196, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 4320, "Date": "2013/09/25" }, { "OrderId": 197, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 7530, "Date": "2013/09/13" }, { "OrderId": 198, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 2820, "Date": "2013/09/08" }, { "OrderId": 199, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 3050, "Date": "2013/09/04" }, { "OrderId": 200, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 5080, "Date": "2013/09/25" }, { "OrderId": 201, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 1125, "Date": "2013/09/13" }, { "OrderId": 202, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 850, "Date": "2013/09/24" }, { "OrderId": 203, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 1440, "Date": "2013/09/19" }, { "OrderId": 204, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 1950, "Date": "2013/09/02" }, { "OrderId": 205, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 6390, "Date": "2013/10/11" }, { "OrderId": 206, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 4625, "Date": "2013/10/02" }, { "OrderId": 207, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 3510, "Date": "2013/10/24" }, { "OrderId": 208, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 2730, "Date": "2013/10/15" }, { "OrderId": 209, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 2070, "Date": "2013/10/15" }, { "OrderId": 210, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 2320, "Date": "2013/10/18" }, { "OrderId": 211, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 4260, "Date": "2013/10/24" }, { "OrderId": 212, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 840, "Date": "2013/10/18" }, { "OrderId": 213, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 7300, "Date": "2013/10/24" }, { "OrderId": 214, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 5950, "Date": "2013/10/11" }, { "OrderId": 215, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 3220, "Date": "2013/10/25" }, { "OrderId": 216, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 3480, "Date": "2013/10/08" }, { "OrderId": 217, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 4830, "Date": "2013/10/26" }, { "OrderId": 218, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 4470, "Date": "2013/10/05" }, { "OrderId": 219, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 3675, "Date": "2013/10/23" }, { "OrderId": 220, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 4260, "Date": "2013/10/01" }, { "OrderId": 221, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 4245, "Date": "2013/10/26" }, { "OrderId": 222, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 1470, "Date": "2013/10/01" }, { "OrderId": 223, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 1810, "Date": "2013/10/02" }, { "OrderId": 224, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 600, "Date": "2013/10/23" }, { "OrderId": 225, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 7500, "Date": "2013/11/03" }, { "OrderId": 226, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 4625, "Date": "2013/11/02" }, { "OrderId": 227, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 2625, "Date": "2013/11/09" }, { "OrderId": 228, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 1440, "Date": "2013/11/15" }, { "OrderId": 229, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 2420, "Date": "2013/11/15" }, { "OrderId": 230, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 4180, "Date": "2013/11/15" }, { "OrderId": 231, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 3720, "Date": "2013/11/25" }, { "OrderId": 232, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 2730, "Date": "2013/11/08" }, { "OrderId": 233, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 3775, "Date": "2013/11/17" }, { "OrderId": 234, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 3525, "Date": "2013/11/15" }, { "OrderId": 235, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 5320, "Date": "2013/11/08" }, { "OrderId": 236, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 5340, "Date": "2013/11/13" }, { "OrderId": 237, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 8850, "Date": "2013/11/01" }, { "OrderId": 238, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 7050, "Date": "2013/11/14" }, { "OrderId": 239, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 4200, "Date": "2013/11/18" }, { "OrderId": 240, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 4960, "Date": "2013/11/04" }, { "OrderId": 241, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 2280, "Date": "2013/11/13" }, { "OrderId": 242, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 590, "Date": "2013/11/11" }, { "OrderId": 243, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 810, "Date": "2013/11/12" }, { "OrderId": 244, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 2625, "Date": "2013/11/07" }, { "OrderId": 245, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 8280, "Date": "2013/12/01" }, { "OrderId": 246, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 5650, "Date": "2013/12/19" }, { "OrderId": 247, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 2760, "Date": "2013/12/14" }, { "OrderId": 248, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 2670, "Date": "2013/12/03" }, { "OrderId": 249, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 2520, "Date": "2013/12/20" }, { "OrderId": 250, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 4080, "Date": "2013/12/21" }, { "OrderId": 251, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 4140, "Date": "2013/12/22" }, { "OrderId": 252, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 390, "Date": "2013/12/04" }, { "OrderId": 253, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 1400, "Date": "2013/12/19" }, { "OrderId": 254, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 7275, "Date": "2013/12/22" }, { "OrderId": 255, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 4100, "Date": "2013/12/20" }, { "OrderId": 256, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 5520, "Date": "2013/12/25" }, { "OrderId": 257, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 9210, "Date": "2013/12/24" }, { "OrderId": 258, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 7290, "Date": "2013/12/05" }, { "OrderId": 259, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 625, "Date": "2013/12/22" }, { "OrderId": 260, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 4460, "Date": "2013/12/12" }, { "OrderId": 261, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 3825, "Date": "2013/12/13" }, { "OrderId": 262, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 2850, "Date": "2013/12/17" }, { "OrderId": 263, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 2780, "Date": "2013/12/07" }, { "OrderId": 264, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 840, "Date": "2013/12/18" }, { "OrderId": 265, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 2970, "Date": "2013/12/23" }, { "OrderId": 266, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 945, "Date": "2013/12/06" }, { "OrderId": 267, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 2625, "Date": "2013/12/04" }, { "OrderId": 268, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 390, "Date": "2013/12/01" }, { "OrderId": 269, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 2250, "Date": "2013/12/02" }, { "OrderId": 270, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 7710, "Date": "2014/01/18" }, { "OrderId": 271, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 7975, "Date": "2014/01/10" }, { "OrderId": 272, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 3285, "Date": "2014/01/13" }, { "OrderId": 273, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 2580, "Date": "2014/01/22" }, { "OrderId": 274, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 2160, "Date": "2014/01/26" }, { "OrderId": 275, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 1100, "Date": "2014/01/25" }, { "OrderId": 276, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 4425, "Date": "2014/01/21" }, { "OrderId": 277, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 1360, "Date": "2014/01/22" }, { "OrderId": 278, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 3250, "Date": "2014/01/14" }, { "OrderId": 279, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 5550, "Date": "2014/01/21" }, { "OrderId": 280, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 2860, "Date": "2014/01/25" }, { "OrderId": 281, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 5320, "Date": "2014/01/08" }, { "OrderId": 282, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 4050, "Date": "2014/01/14" }, { "OrderId": 283, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 3450, "Date": "2014/01/24" }, { "OrderId": 284, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 5425, "Date": "2014/01/11" }, { "OrderId": 285, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 4860, "Date": "2014/01/12" }, { "OrderId": 286, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 4695, "Date": "2014/01/16" }, { "OrderId": 287, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 610, "Date": "2014/01/05" }, { "OrderId": 288, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 1580, "Date": "2014/01/15" }, { "OrderId": 289, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 3780, "Date": "2014/02/18" }, { "OrderId": 290, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 5400, "Date": "2014/02/21" }, { "OrderId": 291, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 630, "Date": "2014/02/18" }, { "OrderId": 292, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 3960, "Date": "2014/02/04" }, { "OrderId": 293, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 2010, "Date": "2014/02/25" }, { "OrderId": 294, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 5000, "Date": "2014/02/01" }, { "OrderId": 295, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 1995, "Date": "2014/02/20" }, { "OrderId": 296, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 860, "Date": "2014/02/12" }, { "OrderId": 297, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 2150, "Date": "2014/02/10" }, { "OrderId": 298, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 4050, "Date": "2014/02/06" }, { "OrderId": 299, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 2960, "Date": "2014/02/18" }, { "OrderId": 300, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 1780, "Date": "2014/02/26" }, { "OrderId": 301, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 8700, "Date": "2014/02/03" }, { "OrderId": 302, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 3390, "Date": "2014/02/03" }, { "OrderId": 303, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 4425, "Date": "2014/02/15" }, { "OrderId": 304, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 1180, "Date": "2014/02/23" }, { "OrderId": 305, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 360, "Date": "2014/02/08" }, { "OrderId": 306, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 2310, "Date": "2014/02/13" }, { "OrderId": 307, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 1770, "Date": "2014/02/20" }, { "OrderId": 308, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 3060, "Date": "2014/02/26" }, { "OrderId": 309, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 1750, "Date": "2014/02/12" }, { "OrderId": 310, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 2280, "Date": "2014/03/09" }, { "OrderId": 311, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 7600, "Date": "2014/03/25" }, { "OrderId": 312, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 1035, "Date": "2014/03/23" }, { "OrderId": 313, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 1245, "Date": "2014/03/01" }, { "OrderId": 314, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 2860, "Date": "2014/03/19" }, { "OrderId": 315, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 440, "Date": "2014/03/19" }, { "OrderId": 316, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 4665, "Date": "2014/03/02" }, { "OrderId": 317, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 2270, "Date": "2014/03/15" }, { "OrderId": 318, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 5000, "Date": "2014/03/09" }, { "OrderId": 319, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 5100, "Date": "2014/03/23" }, { "OrderId": 320, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 2120, "Date": "2014/03/11" }, { "OrderId": 321, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 5140, "Date": "2014/03/05" }, { "OrderId": 322, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 6210, "Date": "2014/03/19" }, { "OrderId": 323, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 9510, "Date": "2014/03/19" }, { "OrderId": 324, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 7600, "Date": "2014/03/21" }, { "OrderId": 325, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 5420, "Date": "2014/03/15" }, { "OrderId": 326, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 1980, "Date": "2014/03/05" }, { "OrderId": 327, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 1820, "Date": "2014/03/07" }, { "OrderId": 328, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 1670, "Date": "2014/03/21" }, { "OrderId": 329, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 4800, "Date": "2014/03/08" }, { "OrderId": 330, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 2925, "Date": "2014/03/03" }, { "OrderId": 331, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 2940, "Date": "2014/04/11" }, { "OrderId": 332, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 3525, "Date": "2014/04/13" }, { "OrderId": 333, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 2475, "Date": "2014/04/22" }, { "OrderId": 334, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 3315, "Date": "2014/04/08" }, { "OrderId": 335, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 3140, "Date": "2014/04/07" }, { "OrderId": 336, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 2520, "Date": "2014/04/01" }, { "OrderId": 337, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 1200, "Date": "2014/04/10" }, { "OrderId": 338, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 2060, "Date": "2014/04/21" }, { "OrderId": 339, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 7875, "Date": "2014/04/02" }, { "OrderId": 340, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 1450, "Date": "2014/04/07" }, { "OrderId": 341, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 2640, "Date": "2014/04/22" }, { "OrderId": 342, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 1960, "Date": "2014/04/16" }, { "OrderId": 343, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 2250, "Date": "2014/04/23" }, { "OrderId": 344, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 4500, "Date": "2014/04/05" }, { "OrderId": 345, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 5050, "Date": "2014/04/11" }, { "OrderId": 346, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 2940, "Date": "2014/04/02" }, { "OrderId": 347, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 2880, "Date": "2014/04/14" }, { "OrderId": 348, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 1050, "Date": "2014/04/19" }, { "OrderId": 349, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 1850, "Date": "2014/04/02" }, { "OrderId": 350, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 3160, "Date": "2014/04/01" }, { "OrderId": 351, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 875, "Date": "2014/04/04" }, { "OrderId": 352, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 3200, "Date": "2014/04/08" }, { "OrderId": 353, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 1380, "Date": "2014/04/21" }, { "OrderId": 354, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 3060, "Date": "2014/04/06" }, { "OrderId": 355, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 6690, "Date": "2014/05/19" }, { "OrderId": 356, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 4525, "Date": "2014/05/15" }, { "OrderId": 357, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 4665, "Date": "2014/05/10" }, { "OrderId": 358, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 4530, "Date": "2014/05/18" }, { "OrderId": 359, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 1330, "Date": "2014/05/08" }, { "OrderId": 360, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 1720, "Date": "2014/05/20" }, { "OrderId": 361, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 3750, "Date": "2014/05/16" }, { "OrderId": 362, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 1290, "Date": "2014/05/10" }, { "OrderId": 363, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 4925, "Date": "2014/05/14" }, { "OrderId": 364, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 4300, "Date": "2014/05/22" }, { "OrderId": 365, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 5740, "Date": "2014/05/08" }, { "OrderId": 366, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 3760, "Date": "2014/05/18" }, { "OrderId": 367, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 7920, "Date": "2014/05/22" }, { "OrderId": 368, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 1440, "Date": "2014/05/21" }, { "OrderId": 369, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 5975, "Date": "2014/05/25" }, { "OrderId": 370, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 4440, "Date": "2014/05/05" }, { "OrderId": 371, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 2310, "Date": "2014/05/24" }, { "OrderId": 372, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 2250, "Date": "2014/05/06" }, { "OrderId": 373, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 2320, "Date": "2014/05/14" }, { "OrderId": 374, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 8370, "Date": "2014/05/06" }, { "OrderId": 375, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 5190, "Date": "2014/06/26" }, { "OrderId": 376, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 925, "Date": "2014/06/04" }, { "OrderId": 377, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 3240, "Date": "2014/06/20" }, { "OrderId": 378, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 3180, "Date": "2014/06/23" }, { "OrderId": 379, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 780, "Date": "2014/06/13" }, { "OrderId": 380, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 4680, "Date": "2014/06/08" }, { "OrderId": 381, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 2475, "Date": "2014/06/25" }, { "OrderId": 382, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 1920, "Date": "2014/06/20" }, { "OrderId": 383, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 7500, "Date": "2014/06/25" }, { "OrderId": 384, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 5025, "Date": "2014/06/26" }, { "OrderId": 385, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 2400, "Date": "2014/06/08" }, { "OrderId": 386, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 1720, "Date": "2014/06/09" }, { "OrderId": 387, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 2880, "Date": "2014/06/21" }, { "OrderId": 388, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 5430, "Date": "2014/06/03" }, { "OrderId": 389, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 4475, "Date": "2014/06/19" }, { "OrderId": 390, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 1420, "Date": "2014/06/20" }, { "OrderId": 391, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 2670, "Date": "2014/06/25" }, { "OrderId": 392, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 1930, "Date": "2014/06/02" }, { "OrderId": 393, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 580, "Date": "2014/06/25" }, { "OrderId": 394, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 1620, "Date": "2014/06/12" }, { "OrderId": 395, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 4530, "Date": "2014/06/02" }, { "OrderId": 396, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 6025, "Date": "2014/06/23" }, { "OrderId": 397, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 3540, "Date": "2014/07/21" }, { "OrderId": 398, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 3000, "Date": "2014/07/01" }, { "OrderId": 399, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 3240, "Date": "2014/07/26" }, { "OrderId": 400, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 2265, "Date": "2014/07/22" }, { "OrderId": 401, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 400, "Date": "2014/07/09" }, { "OrderId": 402, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 1460, "Date": "2014/07/08" }, { "OrderId": 403, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 1620, "Date": "2014/07/18" }, { "OrderId": 404, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 2400, "Date": "2014/07/25" }, { "OrderId": 405, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 5275, "Date": "2014/07/04" }, { "OrderId": 406, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 4475, "Date": "2014/07/03" }, { "OrderId": 407, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 3980, "Date": "2014/07/21" }, { "OrderId": 408, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 5240, "Date": "2014/07/11" }, { "OrderId": 409, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 1200, "Date": "2014/07/21" }, { "OrderId": 410, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 5700, "Date": "2014/07/18" }, { "OrderId": 411, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 5575, "Date": "2014/07/01" }, { "OrderId": 412, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 2160, "Date": "2014/07/02" }, { "OrderId": 413, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 960, "Date": "2014/07/09" }, { "OrderId": 414, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 1280, "Date": "2014/07/04" }, { "OrderId": 415, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 1040, "Date": "2014/07/02" }, { "OrderId": 416, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 5520, "Date": "2014/07/21" }, { "OrderId": 417, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 1760, "Date": "2014/07/25" }, { "OrderId": 418, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 4080, "Date": "2014/07/07" }, { "OrderId": 419, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 1000, "Date": "2014/07/21" }, { "OrderId": 420, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 3270, "Date": "2014/07/12" }, { "OrderId": 421, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 1770, "Date": "2014/08/23" }, { "OrderId": 422, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 2700, "Date": "2014/08/09" }, { "OrderId": 423, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 2175, "Date": "2014/08/03" }, { "OrderId": 424, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 3375, "Date": "2014/08/11" }, { "OrderId": 425, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 2040, "Date": "2014/08/01" }, { "OrderId": 426, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 3000, "Date": "2014/08/21" }, { "OrderId": 427, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 3900, "Date": "2014/08/16" }, { "OrderId": 428, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 1370, "Date": "2014/08/20" }, { "OrderId": 429, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 5700, "Date": "2014/08/01" }, { "OrderId": 430, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 1275, "Date": "2014/08/22" }, { "OrderId": 431, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 4060, "Date": "2014/08/13" }, { "OrderId": 432, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 2320, "Date": "2014/08/18" }, { "OrderId": 433, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 7590, "Date": "2014/08/24" }, { "OrderId": 434, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 4560, "Date": "2014/08/20" }, { "OrderId": 435, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 7575, "Date": "2014/08/20" }, { "OrderId": 436, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 700, "Date": "2014/08/25" }, { "OrderId": 437, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 2400, "Date": "2014/08/16" }, { "OrderId": 438, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 1390, "Date": "2014/08/15" }, { "OrderId": 439, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 1320, "Date": "2014/08/09" }, { "OrderId": 440, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 1680, "Date": "2014/08/09" }, { "OrderId": 441, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 1500, "Date": "2014/08/11" }, { "OrderId": 442, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 6150, "Date": "2014/09/21" }, { "OrderId": 443, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 3675, "Date": "2014/09/02" }, { "OrderId": 444, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 2250, "Date": "2014/09/05" }, { "OrderId": 445, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 3585, "Date": "2014/09/10" }, { "OrderId": 446, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 1470, "Date": "2014/09/01" }, { "OrderId": 447, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 2260, "Date": "2014/09/02" }, { "OrderId": 448, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 3765, "Date": "2014/09/03" }, { "OrderId": 449, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 1640, "Date": "2014/09/04" }, { "OrderId": 450, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 4475, "Date": "2014/09/09" }, { "OrderId": 451, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 5975, "Date": "2014/09/04" }, { "OrderId": 452, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 1100, "Date": "2014/09/16" }, { "OrderId": 453, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 1320, "Date": "2014/09/18" }, { "OrderId": 454, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 8610, "Date": "2014/09/19" }, { "OrderId": 455, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 9210, "Date": "2014/09/09" }, { "OrderId": 456, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 3700, "Date": "2014/09/01" }, { "OrderId": 457, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 3620, "Date": "2014/09/19" }, { "OrderId": 458, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 4275, "Date": "2014/09/01" }, { "OrderId": 459, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 2370, "Date": "2014/09/03" }, { "OrderId": 460, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 1870, "Date": "2014/09/10" }, { "OrderId": 461, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 2070, "Date": "2014/09/25" }, { "OrderId": 462, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 5025, "Date": "2014/09/19" }, { "OrderId": 463, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 1080, "Date": "2014/10/15" }, { "OrderId": 464, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 1400, "Date": "2014/10/22" }, { "OrderId": 465, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 4260, "Date": "2014/10/01" }, { "OrderId": 466, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 2745, "Date": "2014/10/01" }, { "OrderId": 467, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 2920, "Date": "2014/10/23" }, { "OrderId": 468, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 3520, "Date": "2014/10/11" }, { "OrderId": 469, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 4035, "Date": "2014/10/20" }, { "OrderId": 470, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 1730, "Date": "2014/10/05" }, { "OrderId": 471, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 975, "Date": "2014/10/06" }, { "OrderId": 472, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 5700, "Date": "2014/10/06" }, { "OrderId": 473, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 5080, "Date": "2014/10/18" }, { "OrderId": 474, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 2940, "Date": "2014/10/24" }, { "OrderId": 475, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 2670, "Date": "2014/10/04" }, { "OrderId": 476, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 1230, "Date": "2014/10/11" }, { "OrderId": 477, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 600, "Date": "2014/10/08" }, { "OrderId": 478, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 3700, "Date": "2014/10/08" }, { "OrderId": 479, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 3375, "Date": "2014/10/11" }, { "OrderId": 480, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 1500, "Date": "2014/10/17" }, { "OrderId": 481, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 370, "Date": "2014/10/05" }, { "OrderId": 482, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 2340, "Date": "2014/10/16" }, { "OrderId": 483, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 1080, "Date": "2014/10/08" }, { "OrderId": 484, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 2775, "Date": "2014/10/21" }, { "OrderId": 485, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 4380, "Date": "2014/11/09" }, { "OrderId": 486, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 5500, "Date": "2014/11/21" }, { "OrderId": 487, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 1920, "Date": "2014/11/24" }, { "OrderId": 488, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 765, "Date": "2014/11/24" }, { "OrderId": 489, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 370, "Date": "2014/11/18" }, { "OrderId": 490, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 3500, "Date": "2014/11/25" }, { "OrderId": 491, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 825, "Date": "2014/11/09" }, { "OrderId": 492, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 490, "Date": "2014/11/23" }, { "OrderId": 493, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 7075, "Date": "2014/11/20" }, { "OrderId": 494, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 1350, "Date": "2014/11/25" }, { "OrderId": 495, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 1440, "Date": "2014/11/15" }, { "OrderId": 496, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 2820, "Date": "2014/11/13" }, { "OrderId": 497, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 2280, "Date": "2014/11/12" }, { "OrderId": 498, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 1110, "Date": "2014/11/03" }, { "OrderId": 499, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 1150, "Date": "2014/11/23" }, { "OrderId": 500, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 2040, "Date": "2014/11/20" }, { "OrderId": 501, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 3090, "Date": "2014/11/24" }, { "OrderId": 502, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 1940, "Date": "2014/11/24" }, { "OrderId": 503, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 3090, "Date": "2014/11/16" }, { "OrderId": 504, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 4900, "Date": "2014/11/05" }, { "OrderId": 505, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 3465, "Date": "2014/11/07" }, { "OrderId": 506, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 1110, "Date": "2014/11/20" }, { "OrderId": 507, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 1650, "Date": "2014/11/02" }, { "OrderId": 508, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 5280, "Date": "2014/12/04" }, { "OrderId": 509, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 3075, "Date": "2014/12/02" }, { "OrderId": 510, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 690, "Date": "2014/12/07" }, { "OrderId": 511, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 1305, "Date": "2014/12/15" }, { "OrderId": 512, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 1970, "Date": "2014/12/01" }, { "OrderId": 513, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 3760, "Date": "2014/12/18" }, { "OrderId": 514, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 1920, "Date": "2014/12/22" }, { "OrderId": 515, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 1360, "Date": "2014/12/12" }, { "OrderId": 516, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 2525, "Date": "2014/12/06" }, { "OrderId": 517, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 5575, "Date": "2014/12/20" }, { "OrderId": 518, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 5560, "Date": "2014/12/10" }, { "OrderId": 519, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 4880, "Date": "2014/12/13" }, { "OrderId": 520, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 8850, "Date": "2014/12/03" }, { "OrderId": 521, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 2820, "Date": "2014/12/10" }, { "OrderId": 522, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 4000, "Date": "2014/12/12" }, { "OrderId": 523, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 5820, "Date": "2014/12/02" }, { "OrderId": 524, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 1275, "Date": "2014/12/12" }, { "OrderId": 525, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 1310, "Date": "2014/12/01" }, { "OrderId": 526, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 2180, "Date": "2014/12/26" }, { "OrderId": 527, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 4470, "Date": "2014/12/17" }, { "OrderId": 528, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 2990, "Date": "2014/12/15" }, { "OrderId": 529, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 7650, "Date": "2014/12/18" }, { "OrderId": 530, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 780, "Date": "2014/12/02" }, { "OrderId": 531, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 2970, "Date": "2014/12/13" }, { "OrderId": 532, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 1155, "Date": "2014/12/05" }, { "OrderId": 533, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 4470, "Date": "2015/01/10" }, { "OrderId": 534, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 1125, "Date": "2015/01/21" }, { "OrderId": 535, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 645, "Date": "2015/01/17" }, { "OrderId": 536, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 675, "Date": "2015/01/05" }, { "OrderId": 537, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 2840, "Date": "2015/01/05" }, { "OrderId": 538, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 2660, "Date": "2015/01/04" }, { "OrderId": 539, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 4560, "Date": "2015/01/12" }, { "OrderId": 540, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 2880, "Date": "2015/01/20" }, { "OrderId": 541, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 500, "Date": "2015/01/02" }, { "OrderId": 542, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 3925, "Date": "2015/01/07" }, { "OrderId": 543, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 5660, "Date": "2015/01/18" }, { "OrderId": 544, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 1460, "Date": "2015/01/22" }, { "OrderId": 545, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 5040, "Date": "2015/01/10" }, { "OrderId": 546, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 4830, "Date": "2015/01/13" }, { "OrderId": 547, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 3075, "Date": "2015/01/22" }, { "OrderId": 548, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 3120, "Date": "2015/01/14" }, { "OrderId": 549, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 3525, "Date": "2015/01/23" }, { "OrderId": 550, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 1930, "Date": "2015/01/09" }, { "OrderId": 551, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 2890, "Date": "2015/01/02" }, { "OrderId": 552, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 1545, "Date": "2015/01/17" }, { "OrderId": 553, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 3630, "Date": "2015/01/20" }, { "OrderId": 554, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 4035, "Date": "2015/01/14" }, { "OrderId": 555, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 345, "Date": "2015/01/06" }, { "OrderId": 556, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 7000, "Date": "2015/01/07" }, { "OrderId": 557, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 3060, "Date": "2015/02/13" }, { "OrderId": 558, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 6425, "Date": "2015/02/04" }, { "OrderId": 559, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 615, "Date": "2015/02/22" }, { "OrderId": 560, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 1755, "Date": "2015/02/07" }, { "OrderId": 561, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 1540, "Date": "2015/02/21" }, { "OrderId": 562, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 2820, "Date": "2015/02/24" }, { "OrderId": 563, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 4305, "Date": "2015/02/10" }, { "OrderId": 564, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 1520, "Date": "2015/02/26" }, { "OrderId": 565, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 4725, "Date": "2015/02/18" }, { "OrderId": 566, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 6750, "Date": "2015/02/16" }, { "OrderId": 567, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 5540, "Date": "2015/02/07" }, { "OrderId": 568, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 1880, "Date": "2015/02/24" }, { "OrderId": 569, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 6180, "Date": "2015/02/26" }, { "OrderId": 570, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 9300, "Date": "2015/02/03" }, { "OrderId": 571, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 3700, "Date": "2015/02/26" }, { "OrderId": 572, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 740, "Date": "2015/02/01" }, { "OrderId": 573, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 4755, "Date": "2015/02/23" }, { "OrderId": 574, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 2570, "Date": "2015/02/20" }, { "OrderId": 575, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 2860, "Date": "2015/02/19" }, { "OrderId": 576, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 5430, "Date": "2015/03/21" }, { "OrderId": 577, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 4525, "Date": "2015/03/21" }, { "OrderId": 578, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 1515, "Date": "2015/03/10" }, { "OrderId": 579, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 630, "Date": "2015/03/15" }, { "OrderId": 580, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 1310, "Date": "2015/03/01" }, { "OrderId": 581, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 3200, "Date": "2015/03/17" }, { "OrderId": 582, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 3945, "Date": "2015/03/20" }, { "OrderId": 583, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 2990, "Date": "2015/03/18" }, { "OrderId": 584, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 1125, "Date": "2015/03/22" }, { "OrderId": 585, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 7950, "Date": "2015/03/17" }, { "OrderId": 586, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 2960, "Date": "2015/03/25" }, { "OrderId": 587, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 6300, "Date": "2015/03/20" }, { "OrderId": 588, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 8670, "Date": "2015/03/07" }, { "OrderId": 589, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 3930, "Date": "2015/03/23" }, { "OrderId": 590, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 6975, "Date": "2015/03/02" }, { "OrderId": 591, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 4220, "Date": "2015/03/17" }, { "OrderId": 592, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 3090, "Date": "2015/03/25" }, { "OrderId": 593, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 2380, "Date": "2015/03/01" }, { "OrderId": 594, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 1510, "Date": "2015/03/07" }, { "OrderId": 595, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 1020, "Date": "2015/03/19" }, { "OrderId": 596, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 6700, "Date": "2015/03/26" }, { "OrderId": 597, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 4890, "Date": "2015/04/02" }, { "OrderId": 598, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 7225, "Date": "2015/04/13" }, { "OrderId": 599, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 795, "Date": "2015/04/07" }, { "OrderId": 600, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 1785, "Date": "2015/04/03" }, { "OrderId": 601, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 1850, "Date": "2015/04/03" }, { "OrderId": 602, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 5120, "Date": "2015/04/12" }, { "OrderId": 603, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 615, "Date": "2015/04/07" }, { "OrderId": 604, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 2860, "Date": "2015/04/05" }, { "OrderId": 605, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 1525, "Date": "2015/04/24" }, { "OrderId": 606, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 7425, "Date": "2015/04/15" }, { "OrderId": 607, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 6080, "Date": "2015/04/13" }, { "OrderId": 608, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 2940, "Date": "2015/04/04" }, { "OrderId": 609, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 5580, "Date": "2015/04/16" }, { "OrderId": 610, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 9390, "Date": "2015/04/19" }, { "OrderId": 611, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 3200, "Date": "2015/04/26" }, { "OrderId": 612, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 4380, "Date": "2015/04/05" }, { "OrderId": 613, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 4725, "Date": "2015/04/06" }, { "OrderId": 614, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 930, "Date": "2015/04/25" }, { "OrderId": 615, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 1910, "Date": "2015/04/05" }, { "OrderId": 616, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 2725, "Date": "2015/04/16" }, { "OrderId": 617, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 4720, "Date": "2015/04/02" }, { "OrderId": 618, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 5190, "Date": "2015/04/10" }, { "OrderId": 619, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 2800, "Date": "2015/04/26" }, { "OrderId": 620, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 3780, "Date": "2015/04/24" }, { "OrderId": 621, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 2340, "Date": "2015/04/17" }, { "OrderId": 622, "Region": "North America", "Country": "USA", "City": "New York", "Amount": 4830, "Date": "2015/05/12" }, { "OrderId": 623, "Region": "North America", "Country": "USA", "City": "Los Angeles", "Amount": 2075, "Date": "2015/05/23" }, { "OrderId": 624, "Region": "North America", "Country": "USA", "City": "Denver", "Amount": 3420, "Date": "2015/05/21" }, { "OrderId": 625, "Region": "North America", "Country": "CAN", "City": "Vancouver", "Amount": 1440, "Date": "2015/05/10" }, { "OrderId": 626, "Region": "North America", "Country": "CAN", "City": "Edmonton", "Amount": 1680, "Date": "2015/05/15" }, { "OrderId": 627, "Region": "South America", "Country": "BRA", "City": "Rio de Janeiro", "Amount": 3440, "Date": "2015/05/16" }, { "OrderId": 628, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 4695, "Date": "2015/05/10" }, { "OrderId": 629, "Region": "South America", "Country": "PRY", "City": "Asuncion", "Amount": 2380, "Date": "2015/05/06" }, { "OrderId": 630, "Region": "Europe", "Country": "GBR", "City": "London", "Amount": 1875, "Date": "2015/05/25" }, { "OrderId": 631, "Region": "Europe", "Country": "DEU", "City": "Berlin", "Amount": 7550, "Date": "2015/05/14" }, { "OrderId": 632, "Region": "Europe", "Country": "ESP", "City": "Madrid", "Amount": 3340, "Date": "2015/05/01" }, { "OrderId": 633, "Region": "Europe", "Country": "RUS", "City": "Moscow", "Amount": 1400, "Date": "2015/05/22" }, { "OrderId": 634, "Region": "Asia", "Country": "CHN", "City": "Beijing", "Amount": 6060, "Date": "2015/05/22" }, { "OrderId": 635, "Region": "Asia", "Country": "JPN", "City": "Tokyo", "Amount": 8370, "Date": "2015/05/13" }, { "OrderId": 636, "Region": "Asia", "Country": "KOR", "City": "Seoul", "Amount": 3550, "Date": "2015/05/26" }, { "OrderId": 637, "Region": "Australia", "Country": "AUS", "City": "Sydney", "Amount": 2620, "Date": "2015/05/17" }, { "OrderId": 638, "Region": "Australia", "Country": "AUS", "City": "Melbourne", "Amount": 2400, "Date": "2015/05/21" }, { "OrderId": 639, "Region": "Africa", "Country": "ZAF", "City": "Pretoria", "Amount": 1740, "Date": "2015/05/21" }, { "OrderId": 640, "Region": "Africa", "Country": "EGY", "City": "Cairo", "Amount": 500, "Date": "2015/05/26" }, { "OrderId": 641, "Region": "South America", "Country": "ARG", "City": "Buenos Aires", "Amount": 780, "Date": "2015/05/07" }];
#sales { margin-top: 80px; } .long-title h3 { font-family: 'Segoe UI Light', 'Helvetica Neue Light', 'Segoe UI', 'Helvetica Neue', 'Trebuchet MS', Verdana; font-weight: 200; font-size: 28px; text-align: center; margin-bottom: 20px; }

You can distribute fields between four different areas: row, column, filter, and data. To specify the area, set the area property. Fields that do not belong to any area are displayed in the field chooser.

For more information on fields and areas, refer to the following article: Fields and Areas.