Your search did not match any results.

Chart Integration

PivotGrid allows you to integrate the Chart component to visualize data. The Chart is synchronized with the PivotGrid and visualizes the currently displayed total summary values. Expand a row or column header in the PivotGrid below to see how it works.

Backend API
@using DevExtreme.MVC.Demos.Models <div id="pivotgrid-demo"> @(Html.DevExtreme().Chart() .ID("pivotgrid-chart") .CommonSeriesSettings(s => s.Type(SeriesType.Bar)) .Tooltip(t => t.Enabled(true).CustomizeTooltip("customize_tooltip")) .Size(s => s.Height(320)) .AdaptiveLayout(l => l.Width(450)) ) @(Html.DevExtreme().PivotGrid<Sale>() .ID("pivotgrid") .AllowSortingBySummary(true) .AllowFiltering(true) .ShowBorders(true) .ShowColumnGrandTotals(false) .ShowRowGrandTotals(false) .ShowRowTotals(false) .ShowColumnTotals(false) .FieldChooser(c => c.Enabled(true)) .DataSource(d => d .Store(s => s.WebApi().Controller("PivotGridData")) .Fields(fields => { fields.AddFor(m => m.Region) .Width(120) .Area(PivotGridArea.Row) .SortBySummaryField("Total"); fields.AddFor(m => m.City) .Width(150) .Area(PivotGridArea.Row); fields.AddFor(m => m.Date) .Area(PivotGridArea.Column); fields.Add() .GroupName("Date") .GroupInterval(PivotGridGroupInterval.Month) .Visible(false); fields.AddFor(m => m.Amount) .SummaryType(SummaryType.Sum) .Format(Format.Currency) .Area(PivotGridArea.Data); fields.Add() .SummaryType(SummaryType.Count) .Area(PivotGridArea.Data); }) ) .OnContentReady("bind_chart") ) </div> <script> function formatCurrency(value) { return "$" + new Intl.NumberFormat("en-US", { maximumFractionDigits: 0 }).format(value); } function customize_tooltip(args) { var valueText = (args.seriesName.indexOf("Total") != -1) ? formatCurrency(args.originalValue) : args.originalValue; return { html: args.seriesName + "<div class='currency'>" + valueText + "</div>" }; } function bind_chart(e) { e.component.bindChart($("#pivotgrid-chart"), { dataFieldsDisplayMode: "splitPanes", alternateDataFields: false }); } </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 ChartIntegration() { return View(); } } }
using System; using System.Collections.Generic; using System.Linq; using System.Net.Http; using System.Web.Http; using DevExtreme.AspNet.Data; using DevExtreme.AspNet.Mvc; using DevExtreme.MVC.Demos.Models.SampleData; namespace DevExtreme.MVC.Demos.Controllers.ApiControllers { public class PivotGridDataController : ApiController { [HttpGet] public HttpResponseMessage Get(DataSourceLoadOptions loadOptions) { return Request.CreateResponse(DataSourceLoader.Load(SampleData.Sales, loadOptions)); } } }
using System; using System.Collections.Generic; using System.ComponentModel.DataAnnotations; using System.Linq; using System.Web; namespace DevExtreme.MVC.Demos.Models { public class Sale { [Display(Name = "Order ID")] public int OrderId { get; set; } public string Region { get; set; } public string Country { get; set; } public string City { get; set; } [Display(Name = "Total")] public int Amount { get; set; } public DateTime Date { get; set; } } }
using System; using System.Collections.Generic; namespace DevExtreme.MVC.Demos.Models.SampleData { public partial class SampleData { public static readonly IEnumerable<Sale> Sales = new[] { new Sale { OrderId = 10248, Region = "North America", Country = "United States", City = "New York", Amount = 1740, Date = DateTime.Parse("2013/01/06") }, new Sale { OrderId = 10249, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 850, Date = DateTime.Parse("2013/01/13") }, new Sale { OrderId = 10250, Region = "North America", Country = "United States", City = "Denver", Amount = 2235, Date = DateTime.Parse("2013/01/07") }, new Sale { OrderId = 10251, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 1965, Date = DateTime.Parse("2013/01/03") }, new Sale { OrderId = 10252, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 880, Date = DateTime.Parse("2013/01/10") }, new Sale { OrderId = 10253, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 5260, Date = DateTime.Parse("2013/01/17") }, new Sale { OrderId = 10254, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 2790, Date = DateTime.Parse("2013/01/21") }, new Sale { OrderId = 10255, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 3140, Date = DateTime.Parse("2013/01/01") }, new Sale { OrderId = 10256, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 6175, Date = DateTime.Parse("2013/01/24") }, new Sale { OrderId = 10257, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 4575, Date = DateTime.Parse("2013/01/11") }, new Sale { OrderId = 10258, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 3680, Date = DateTime.Parse("2013/01/12") }, new Sale { OrderId = 10259, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 2260, Date = DateTime.Parse("2013/01/01") }, new Sale { OrderId = 10260, Region = "Asia", Country = "China", City = "Beijing", Amount = 2910, Date = DateTime.Parse("2013/01/26") }, new Sale { OrderId = 10261, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 8400, Date = DateTime.Parse("2013/01/05") }, new Sale { OrderId = 10262, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 1325, Date = DateTime.Parse("2013/01/14") }, new Sale { OrderId = 10263, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 3920, Date = DateTime.Parse("2013/01/05") }, new Sale { OrderId = 10264, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 2220, Date = DateTime.Parse("2013/01/15") }, new Sale { OrderId = 10265, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 940, Date = DateTime.Parse("2013/01/01") }, new Sale { OrderId = 10266, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 1630, Date = DateTime.Parse("2013/01/10") }, new Sale { OrderId = 10267, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 2910, Date = DateTime.Parse("2013/01/23") }, new Sale { OrderId = 10268, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 2600, Date = DateTime.Parse("2013/01/14") }, new Sale { OrderId = 10269, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 4340, Date = DateTime.Parse("2013/01/26") }, new Sale { OrderId = 10270, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 6650, Date = DateTime.Parse("2013/01/24") }, new Sale { OrderId = 10271, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 490, Date = DateTime.Parse("2013/01/22") }, new Sale { OrderId = 10272, Region = "North America", Country = "United States", City = "New York", Amount = 3390, Date = DateTime.Parse("2013/01/25") }, new Sale { OrderId = 10273, Region = "North America", Country = "United States", City = "New York", Amount = 5160, Date = DateTime.Parse("2013/02/20") }, new Sale { OrderId = 10274, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 5750, Date = DateTime.Parse("2013/02/12") }, new Sale { OrderId = 10275, Region = "North America", Country = "United States", City = "Denver", Amount = 2805, Date = DateTime.Parse("2013/02/13") }, new Sale { OrderId = 10276, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 2505, Date = DateTime.Parse("2013/02/09") }, new Sale { OrderId = 10277, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 930, Date = DateTime.Parse("2013/02/04") }, new Sale { OrderId = 10278, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 1240, Date = DateTime.Parse("2013/02/03") }, new Sale { OrderId = 10279, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 315, Date = DateTime.Parse("2013/02/04") }, new Sale { OrderId = 10280, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 2870, Date = DateTime.Parse("2013/02/18") }, new Sale { OrderId = 10281, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 5150, Date = DateTime.Parse("2013/02/18") }, new Sale { OrderId = 10282, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 2725, Date = DateTime.Parse("2013/02/20") }, new Sale { OrderId = 10283, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 2840, Date = DateTime.Parse("2013/02/04") }, new Sale { OrderId = 10284, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 5840, Date = DateTime.Parse("2013/02/13") }, new Sale { OrderId = 10285, Region = "Asia", Country = "China", City = "Beijing", Amount = 6750, Date = DateTime.Parse("2013/02/11") }, new Sale { OrderId = 10286, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 1200, Date = DateTime.Parse("2013/02/03") }, new Sale { OrderId = 10287, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 4550, Date = DateTime.Parse("2013/02/08") }, new Sale { OrderId = 10288, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 6040, Date = DateTime.Parse("2013/02/17") }, new Sale { OrderId = 10289, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 2205, Date = DateTime.Parse("2013/02/08") }, new Sale { OrderId = 10290, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 990, Date = DateTime.Parse("2013/02/20") }, new Sale { OrderId = 10291, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 700, Date = DateTime.Parse("2013/02/11") }, new Sale { OrderId = 10292, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 2325, Date = DateTime.Parse("2013/02/15") }, new Sale { OrderId = 10293, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 930, Date = DateTime.Parse("2013/02/21") }, new Sale { OrderId = 10294, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 1560, Date = DateTime.Parse("2013/02/04") }, new Sale { OrderId = 10295, Region = "North America", Country = "United States", City = "New York", Amount = 1740, Date = DateTime.Parse("2013/03/04") }, new Sale { OrderId = 10296, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 3575, Date = DateTime.Parse("2013/03/20") }, new Sale { OrderId = 10297, Region = "North America", Country = "United States", City = "Denver", Amount = 4500, Date = DateTime.Parse("2013/03/04") }, new Sale { OrderId = 10298, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 1605, Date = DateTime.Parse("2013/03/17") }, new Sale { OrderId = 10299, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 800, Date = DateTime.Parse("2013/03/21") }, new Sale { OrderId = 10300, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 640, Date = DateTime.Parse("2013/03/08") }, new Sale { OrderId = 10301, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 735, Date = DateTime.Parse("2013/03/19") }, new Sale { OrderId = 10302, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 2520, Date = DateTime.Parse("2013/03/20") }, new Sale { OrderId = 10303, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 6675, Date = DateTime.Parse("2013/03/18") }, new Sale { OrderId = 10304, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 3625, Date = DateTime.Parse("2013/03/25") }, new Sale { OrderId = 10305, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 1200, Date = DateTime.Parse("2013/03/07") }, new Sale { OrderId = 10306, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 2000, Date = DateTime.Parse("2013/03/07") }, new Sale { OrderId = 10307, Region = "Asia", Country = "China", City = "Beijing", Amount = 1410, Date = DateTime.Parse("2013/03/10") }, new Sale { OrderId = 10308, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 2700, Date = DateTime.Parse("2013/03/19") }, new Sale { OrderId = 10309, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 5950, Date = DateTime.Parse("2013/03/24") }, new Sale { OrderId = 10310, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 5120, Date = DateTime.Parse("2013/03/08") }, new Sale { OrderId = 10311, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 1980, Date = DateTime.Parse("2013/03/17") }, new Sale { OrderId = 10312, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 1110, Date = DateTime.Parse("2013/03/08") }, new Sale { OrderId = 10313, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 980, Date = DateTime.Parse("2013/03/21") }, new Sale { OrderId = 10314, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 5460, Date = DateTime.Parse("2013/03/19") }, new Sale { OrderId = 10315, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 3800, Date = DateTime.Parse("2013/03/12") }, new Sale { OrderId = 10316, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 2610, Date = DateTime.Parse("2013/03/04") }, new Sale { OrderId = 10317, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 3080, Date = DateTime.Parse("2013/03/22") }, new Sale { OrderId = 10318, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 2010, Date = DateTime.Parse("2013/03/23") }, new Sale { OrderId = 10319, Region = "Asia", Country = "China", City = "Beijing", Amount = 1200, Date = DateTime.Parse("2013/03/04") }, new Sale { OrderId = 10320, Region = "North America", Country = "United States", City = "New York", Amount = 7680, Date = DateTime.Parse("2013/04/15") }, new Sale { OrderId = 10321, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 1325, Date = DateTime.Parse("2013/04/07") }, new Sale { OrderId = 10322, Region = "North America", Country = "United States", City = "Denver", Amount = 2835, Date = DateTime.Parse("2013/04/10") }, new Sale { OrderId = 10323, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 3660, Date = DateTime.Parse("2013/04/10") }, new Sale { OrderId = 10324, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 390, Date = DateTime.Parse("2013/04/12") }, new Sale { OrderId = 10325, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 4420, Date = DateTime.Parse("2013/04/08") }, new Sale { OrderId = 10326, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 1755, Date = DateTime.Parse("2013/04/13") }, new Sale { OrderId = 10327, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 2580, Date = DateTime.Parse("2013/04/15") }, new Sale { OrderId = 10328, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 850, Date = DateTime.Parse("2013/04/01") }, new Sale { OrderId = 10329, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 2825, Date = DateTime.Parse("2013/04/10") }, new Sale { OrderId = 10330, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 540, Date = DateTime.Parse("2013/04/06") }, new Sale { OrderId = 10331, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 1520, Date = DateTime.Parse("2013/04/08") }, new Sale { OrderId = 10332, Region = "Asia", Country = "China", City = "Beijing", Amount = 8760, Date = DateTime.Parse("2013/04/26") }, new Sale { OrderId = 10333, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 1110, Date = DateTime.Parse("2013/04/16") }, new Sale { OrderId = 10334, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 6850, Date = DateTime.Parse("2013/04/19") }, new Sale { OrderId = 10335, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 1940, Date = DateTime.Parse("2013/04/23") }, new Sale { OrderId = 10336, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 1980, Date = DateTime.Parse("2013/04/21") }, new Sale { OrderId = 10337, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 3090, Date = DateTime.Parse("2013/04/03") }, new Sale { OrderId = 10338, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 1640, Date = DateTime.Parse("2013/04/24") }, new Sale { OrderId = 10339, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 3585, Date = DateTime.Parse("2013/04/01") }, new Sale { OrderId = 10340, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 1770, Date = DateTime.Parse("2013/04/01") }, new Sale { OrderId = 10341, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 4005, Date = DateTime.Parse("2013/04/04") }, new Sale { OrderId = 10342, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 2870, Date = DateTime.Parse("2013/04/02") }, new Sale { OrderId = 10343, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 960, Date = DateTime.Parse("2013/04/20") }, new Sale { OrderId = 10344, Region = "North America", Country = "United States", City = "New York", Amount = 8640, Date = DateTime.Parse("2013/05/14") }, new Sale { OrderId = 10345, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 5450, Date = DateTime.Parse("2013/05/24") }, new Sale { OrderId = 10346, Region = "North America", Country = "United States", City = "Denver", Amount = 2535, Date = DateTime.Parse("2013/05/07") }, new Sale { OrderId = 10347, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 1155, Date = DateTime.Parse("2013/05/20") }, new Sale { OrderId = 10348, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 3140, Date = DateTime.Parse("2013/05/18") }, new Sale { OrderId = 10349, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 2260, Date = DateTime.Parse("2013/05/19") }, new Sale { OrderId = 10350, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 1215, Date = DateTime.Parse("2013/05/23") }, new Sale { OrderId = 10351, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 1210, Date = DateTime.Parse("2013/05/08") }, new Sale { OrderId = 10352, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 875, Date = DateTime.Parse("2013/05/25") }, new Sale { OrderId = 10353, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 5400, Date = DateTime.Parse("2013/05/03") }, new Sale { OrderId = 10354, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 5940, Date = DateTime.Parse("2013/05/25") }, new Sale { OrderId = 10355, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 4700, Date = DateTime.Parse("2013/05/03") }, new Sale { OrderId = 10356, Region = "Asia", Country = "China", City = "Beijing", Amount = 5520, Date = DateTime.Parse("2013/05/12") }, new Sale { OrderId = 10357, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 9210, Date = DateTime.Parse("2013/05/22") }, new Sale { OrderId = 10358, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 7950, Date = DateTime.Parse("2013/05/12") }, new Sale { OrderId = 10359, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 3740, Date = DateTime.Parse("2013/05/24") }, new Sale { OrderId = 10360, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 990, Date = DateTime.Parse("2013/05/02") }, new Sale { OrderId = 10361, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 3190, Date = DateTime.Parse("2013/05/03") }, new Sale { OrderId = 10362, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 2430, Date = DateTime.Parse("2013/05/11") }, new Sale { OrderId = 10363, Region = "North America", Country = "United States", City = "New York", Amount = 7380, Date = DateTime.Parse("2013/06/15") }, new Sale { OrderId = 10364, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 4475, Date = DateTime.Parse("2013/06/08") }, new Sale { OrderId = 10365, Region = "North America", Country = "United States", City = "Denver", Amount = 1290, Date = DateTime.Parse("2013/06/10") }, new Sale { OrderId = 10366, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 2250, Date = DateTime.Parse("2013/06/10") }, new Sale { OrderId = 10367, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 350, Date = DateTime.Parse("2013/06/22") }, new Sale { OrderId = 10368, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 5480, Date = DateTime.Parse("2013/06/24") }, new Sale { OrderId = 10369, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 2355, Date = DateTime.Parse("2013/06/10") }, new Sale { OrderId = 10370, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 1960, Date = DateTime.Parse("2013/06/23") }, new Sale { OrderId = 10371, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 4125, Date = DateTime.Parse("2013/06/06") }, new Sale { OrderId = 10372, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 7925, Date = DateTime.Parse("2013/06/12") }, new Sale { OrderId = 10373, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 1120, Date = DateTime.Parse("2013/06/22") }, new Sale { OrderId = 10374, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 5100, Date = DateTime.Parse("2013/06/01") }, new Sale { OrderId = 10375, Region = "Asia", Country = "China", City = "Beijing", Amount = 1500, Date = DateTime.Parse("2013/06/25") }, new Sale { OrderId = 10376, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 5130, Date = DateTime.Parse("2013/06/10") }, new Sale { OrderId = 10377, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 2475, Date = DateTime.Parse("2013/06/10") }, new Sale { OrderId = 10378, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 2100, Date = DateTime.Parse("2013/06/06") }, new Sale { OrderId = 10379, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 3570, Date = DateTime.Parse("2013/06/10") }, new Sale { OrderId = 10380, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 550, Date = DateTime.Parse("2013/06/02") }, new Sale { OrderId = 10381, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 2850, Date = DateTime.Parse("2013/06/26") }, new Sale { OrderId = 10382, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 4280, Date = DateTime.Parse("2013/06/19") }, new Sale { OrderId = 10383, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 1460, Date = DateTime.Parse("2013/06/17") }, new Sale { OrderId = 10384, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 960, Date = DateTime.Parse("2013/06/17") }, new Sale { OrderId = 10385, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 1520, Date = DateTime.Parse("2013/06/03") }, new Sale { OrderId = 10386, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 6750, Date = DateTime.Parse("2013/06/21") }, new Sale { OrderId = 10387, Region = "North America", Country = "United States", City = "New York", Amount = 7260, Date = DateTime.Parse("2013/07/14") }, new Sale { OrderId = 10388, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 2450, Date = DateTime.Parse("2013/07/11") }, new Sale { OrderId = 10389, Region = "North America", Country = "United States", City = "Denver", Amount = 3540, Date = DateTime.Parse("2013/07/02") }, new Sale { OrderId = 10390, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 1950, Date = DateTime.Parse("2013/07/03") }, new Sale { OrderId = 10391, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 360, Date = DateTime.Parse("2013/07/07") }, new Sale { OrderId = 10392, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 4500, Date = DateTime.Parse("2013/07/03") }, new Sale { OrderId = 10393, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 4575, Date = DateTime.Parse("2013/07/21") }, new Sale { OrderId = 10394, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 2310, Date = DateTime.Parse("2013/07/18") }, new Sale { OrderId = 10395, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 7500, Date = DateTime.Parse("2013/07/04") }, new Sale { OrderId = 10396, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 3575, Date = DateTime.Parse("2013/07/23") }, new Sale { OrderId = 10397, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 760, Date = DateTime.Parse("2013/07/01") }, new Sale { OrderId = 10398, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 2400, Date = DateTime.Parse("2013/07/11") }, new Sale { OrderId = 10399, Region = "Asia", Country = "China", City = "Beijing", Amount = 3330, Date = DateTime.Parse("2013/07/04") }, new Sale { OrderId = 10400, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 3480, Date = DateTime.Parse("2013/07/23") }, new Sale { OrderId = 10401, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 4875, Date = DateTime.Parse("2013/07/11") }, new Sale { OrderId = 10402, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 4980, Date = DateTime.Parse("2013/07/19") }, new Sale { OrderId = 10403, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 2580, Date = DateTime.Parse("2013/07/04") }, new Sale { OrderId = 10404, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 2650, Date = DateTime.Parse("2013/07/16") }, new Sale { OrderId = 10405, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 1190, Date = DateTime.Parse("2013/07/02") }, new Sale { OrderId = 10406, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 960, Date = DateTime.Parse("2013/07/26") }, new Sale { OrderId = 10407, Region = "North America", Country = "United States", City = "New York", Amount = 3600, Date = DateTime.Parse("2013/08/08") }, new Sale { OrderId = 10408, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 2250, Date = DateTime.Parse("2013/08/01") }, new Sale { OrderId = 10409, Region = "North America", Country = "United States", City = "Denver", Amount = 1275, Date = DateTime.Parse("2013/08/02") }, new Sale { OrderId = 10410, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 3885, Date = DateTime.Parse("2013/08/14") }, new Sale { OrderId = 10411, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 1900, Date = DateTime.Parse("2013/08/05") }, new Sale { OrderId = 10412, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 2300, Date = DateTime.Parse("2013/08/09") }, new Sale { OrderId = 10413, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 2895, Date = DateTime.Parse("2013/08/15") }, new Sale { OrderId = 10414, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 350, Date = DateTime.Parse("2013/08/20") }, new Sale { OrderId = 10415, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 4200, Date = DateTime.Parse("2013/08/22") }, new Sale { OrderId = 10416, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 7175, Date = DateTime.Parse("2013/08/14") }, new Sale { OrderId = 10417, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 4420, Date = DateTime.Parse("2013/08/24") }, new Sale { OrderId = 10418, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 5200, Date = DateTime.Parse("2013/08/21") }, new Sale { OrderId = 10419, Region = "Asia", Country = "China", City = "Beijing", Amount = 7920, Date = DateTime.Parse("2013/08/17") }, new Sale { OrderId = 10420, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 6990, Date = DateTime.Parse("2013/08/22") }, new Sale { OrderId = 10421, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 2125, Date = DateTime.Parse("2013/08/05") }, new Sale { OrderId = 10422, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 2220, Date = DateTime.Parse("2013/08/16") }, new Sale { OrderId = 10423, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 1575, Date = DateTime.Parse("2013/08/23") }, new Sale { OrderId = 10424, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 1880, Date = DateTime.Parse("2013/08/12") }, new Sale { OrderId = 10425, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 710, Date = DateTime.Parse("2013/08/25") }, new Sale { OrderId = 10426, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 390, Date = DateTime.Parse("2013/08/20") }, new Sale { OrderId = 10427, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 4635, Date = DateTime.Parse("2013/08/04") }, new Sale { OrderId = 10428, Region = "North America", Country = "United States", City = "Denver", Amount = 4350, Date = DateTime.Parse("2013/08/19") }, new Sale { OrderId = 10429, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 6020, Date = DateTime.Parse("2013/08/02") }, new Sale { OrderId = 10430, Region = "North America", Country = "United States", City = "New York", Amount = 3660, Date = DateTime.Parse("2013/08/19") }, new Sale { OrderId = 10431, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 4525, Date = DateTime.Parse("2013/08/24") }, new Sale { OrderId = 10432, Region = "North America", Country = "United States", City = "New York", Amount = 4410, Date = DateTime.Parse("2013/09/12") }, new Sale { OrderId = 10433, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 1725, Date = DateTime.Parse("2013/09/07") }, new Sale { OrderId = 10434, Region = "North America", Country = "United States", City = "Denver", Amount = 2715, Date = DateTime.Parse("2013/09/14") }, new Sale { OrderId = 10435, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 2820, Date = DateTime.Parse("2013/09/08") }, new Sale { OrderId = 10436, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 2310, Date = DateTime.Parse("2013/09/12") }, new Sale { OrderId = 10437, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 780, Date = DateTime.Parse("2013/09/08") }, new Sale { OrderId = 10438, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 2370, Date = DateTime.Parse("2013/09/19") }, new Sale { OrderId = 10439, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 1410, Date = DateTime.Parse("2013/09/09") }, new Sale { OrderId = 10440, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 1825, Date = DateTime.Parse("2013/09/23") }, new Sale { OrderId = 10441, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 4075, Date = DateTime.Parse("2013/09/06") }, new Sale { OrderId = 10442, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 1020, Date = DateTime.Parse("2013/09/04") }, new Sale { OrderId = 10443, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 4320, Date = DateTime.Parse("2013/09/25") }, new Sale { OrderId = 10444, Region = "Asia", Country = "China", City = "Beijing", Amount = 7530, Date = DateTime.Parse("2013/09/13") }, new Sale { OrderId = 10445, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 2820, Date = DateTime.Parse("2013/09/08") }, new Sale { OrderId = 10446, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 3050, Date = DateTime.Parse("2013/09/04") }, new Sale { OrderId = 10447, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 5080, Date = DateTime.Parse("2013/09/25") }, new Sale { OrderId = 10448, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 1125, Date = DateTime.Parse("2013/09/13") }, new Sale { OrderId = 10449, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 850, Date = DateTime.Parse("2013/09/24") }, new Sale { OrderId = 10450, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 1440, Date = DateTime.Parse("2013/09/19") }, new Sale { OrderId = 10451, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 1950, Date = DateTime.Parse("2013/09/02") }, new Sale { OrderId = 10452, Region = "North America", Country = "United States", City = "New York", Amount = 6390, Date = DateTime.Parse("2013/10/11") }, new Sale { OrderId = 10453, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 4625, Date = DateTime.Parse("2013/10/02") }, new Sale { OrderId = 10454, Region = "North America", Country = "United States", City = "Denver", Amount = 3510, Date = DateTime.Parse("2013/10/24") }, new Sale { OrderId = 10455, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 2730, Date = DateTime.Parse("2013/10/15") }, new Sale { OrderId = 10456, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 2070, Date = DateTime.Parse("2013/10/15") }, new Sale { OrderId = 10457, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 2320, Date = DateTime.Parse("2013/10/18") }, new Sale { OrderId = 10458, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 4260, Date = DateTime.Parse("2013/10/24") }, new Sale { OrderId = 10459, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 840, Date = DateTime.Parse("2013/10/18") }, new Sale { OrderId = 10460, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 7300, Date = DateTime.Parse("2013/10/24") }, new Sale { OrderId = 10461, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 5950, Date = DateTime.Parse("2013/10/11") }, new Sale { OrderId = 10462, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 3220, Date = DateTime.Parse("2013/10/25") }, new Sale { OrderId = 10463, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 3480, Date = DateTime.Parse("2013/10/08") }, new Sale { OrderId = 10464, Region = "Asia", Country = "China", City = "Beijing", Amount = 4830, Date = DateTime.Parse("2013/10/26") }, new Sale { OrderId = 10465, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 4470, Date = DateTime.Parse("2013/10/05") }, new Sale { OrderId = 10466, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 3675, Date = DateTime.Parse("2013/10/23") }, new Sale { OrderId = 10467, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 4260, Date = DateTime.Parse("2013/10/01") }, new Sale { OrderId = 10468, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 4245, Date = DateTime.Parse("2013/10/26") }, new Sale { OrderId = 10469, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 1470, Date = DateTime.Parse("2013/10/01") }, new Sale { OrderId = 10470, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 1810, Date = DateTime.Parse("2013/10/02") }, new Sale { OrderId = 10471, Region = "North America", Country = "United States", City = "New York", Amount = 600, Date = DateTime.Parse("2013/10/23") }, new Sale { OrderId = 10472, Region = "North America", Country = "United States", City = "New York", Amount = 7500, Date = DateTime.Parse("2013/11/03") }, new Sale { OrderId = 10473, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 4625, Date = DateTime.Parse("2013/11/02") }, new Sale { OrderId = 10474, Region = "North America", Country = "United States", City = "Denver", Amount = 2625, Date = DateTime.Parse("2013/11/09") }, new Sale { OrderId = 10475, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 1440, Date = DateTime.Parse("2013/11/15") }, new Sale { OrderId = 10476, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 2420, Date = DateTime.Parse("2013/11/15") }, new Sale { OrderId = 10477, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 4180, Date = DateTime.Parse("2013/11/15") }, new Sale { OrderId = 10478, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 3720, Date = DateTime.Parse("2013/11/25") }, new Sale { OrderId = 10479, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 2730, Date = DateTime.Parse("2013/11/08") }, new Sale { OrderId = 10480, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 3775, Date = DateTime.Parse("2013/11/17") }, new Sale { OrderId = 10481, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 3525, Date = DateTime.Parse("2013/11/15") }, new Sale { OrderId = 10482, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 5320, Date = DateTime.Parse("2013/11/08") }, new Sale { OrderId = 10483, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 5340, Date = DateTime.Parse("2013/11/13") }, new Sale { OrderId = 10484, Region = "Asia", Country = "China", City = "Beijing", Amount = 8850, Date = DateTime.Parse("2013/11/01") }, new Sale { OrderId = 10485, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 7050, Date = DateTime.Parse("2013/11/14") }, new Sale { OrderId = 10486, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 4200, Date = DateTime.Parse("2013/11/18") }, new Sale { OrderId = 10487, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 4960, Date = DateTime.Parse("2013/11/04") }, new Sale { OrderId = 10488, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 2280, Date = DateTime.Parse("2013/11/13") }, new Sale { OrderId = 10489, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 590, Date = DateTime.Parse("2013/11/11") }, new Sale { OrderId = 10490, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 810, Date = DateTime.Parse("2013/11/12") }, new Sale { OrderId = 10491, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 2625, Date = DateTime.Parse("2013/11/07") }, new Sale { OrderId = 10492, Region = "North America", Country = "United States", City = "New York", Amount = 8280, Date = DateTime.Parse("2013/12/01") }, new Sale { OrderId = 10493, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 5650, Date = DateTime.Parse("2013/12/19") }, new Sale { OrderId = 10494, Region = "North America", Country = "United States", City = "Denver", Amount = 2760, Date = DateTime.Parse("2013/12/14") }, new Sale { OrderId = 10495, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 2670, Date = DateTime.Parse("2013/12/03") }, new Sale { OrderId = 10496, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 2520, Date = DateTime.Parse("2013/12/20") }, new Sale { OrderId = 10497, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 4080, Date = DateTime.Parse("2013/12/21") }, new Sale { OrderId = 10498, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 4140, Date = DateTime.Parse("2013/12/22") }, new Sale { OrderId = 10499, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 390, Date = DateTime.Parse("2013/12/04") }, new Sale { OrderId = 10500, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 1400, Date = DateTime.Parse("2013/12/19") }, new Sale { OrderId = 10501, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 7275, Date = DateTime.Parse("2013/12/22") }, new Sale { OrderId = 10502, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 4100, Date = DateTime.Parse("2013/12/20") }, new Sale { OrderId = 10503, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 5520, Date = DateTime.Parse("2013/12/25") }, new Sale { OrderId = 10504, Region = "Asia", Country = "China", City = "Beijing", Amount = 9210, Date = DateTime.Parse("2013/12/24") }, new Sale { OrderId = 10505, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 7290, Date = DateTime.Parse("2013/12/05") }, new Sale { OrderId = 10506, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 625, Date = DateTime.Parse("2013/12/22") }, new Sale { OrderId = 10507, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 4460, Date = DateTime.Parse("2013/12/12") }, new Sale { OrderId = 10508, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 3825, Date = DateTime.Parse("2013/12/13") }, new Sale { OrderId = 10509, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 2850, Date = DateTime.Parse("2013/12/17") }, new Sale { OrderId = 10510, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 2780, Date = DateTime.Parse("2013/12/07") }, new Sale { OrderId = 10511, Region = "North America", Country = "United States", City = "New York", Amount = 840, Date = DateTime.Parse("2013/12/18") }, new Sale { OrderId = 10512, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 2970, Date = DateTime.Parse("2013/12/23") }, new Sale { OrderId = 10513, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 945, Date = DateTime.Parse("2013/12/06") }, new Sale { OrderId = 10514, Region = "North America", Country = "United States", City = "Denver", Amount = 2625, Date = DateTime.Parse("2013/12/04") }, new Sale { OrderId = 10515, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 390, Date = DateTime.Parse("2013/12/01") }, new Sale { OrderId = 10516, Region = "Asia", Country = "China", City = "Beijing", Amount = 2250, Date = DateTime.Parse("2013/12/02") }, new Sale { OrderId = 10517, Region = "North America", Country = "United States", City = "New York", Amount = 7710, Date = DateTime.Parse("2014/01/18") }, new Sale { OrderId = 10518, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 7975, Date = DateTime.Parse("2014/01/10") }, new Sale { OrderId = 10519, Region = "North America", Country = "United States", City = "Denver", Amount = 3285, Date = DateTime.Parse("2014/01/13") }, new Sale { OrderId = 10520, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 2580, Date = DateTime.Parse("2014/01/22") }, new Sale { OrderId = 10521, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 2160, Date = DateTime.Parse("2014/01/26") }, new Sale { OrderId = 10522, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 1100, Date = DateTime.Parse("2014/01/25") }, new Sale { OrderId = 10523, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 4425, Date = DateTime.Parse("2014/01/21") }, new Sale { OrderId = 10524, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 1360, Date = DateTime.Parse("2014/01/22") }, new Sale { OrderId = 10525, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 3250, Date = DateTime.Parse("2014/01/14") }, new Sale { OrderId = 10526, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 5550, Date = DateTime.Parse("2014/01/21") }, new Sale { OrderId = 10527, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 2860, Date = DateTime.Parse("2014/01/25") }, new Sale { OrderId = 10528, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 5320, Date = DateTime.Parse("2014/01/08") }, new Sale { OrderId = 10529, Region = "Asia", Country = "China", City = "Beijing", Amount = 4050, Date = DateTime.Parse("2014/01/14") }, new Sale { OrderId = 10530, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 3450, Date = DateTime.Parse("2014/01/24") }, new Sale { OrderId = 10531, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 5425, Date = DateTime.Parse("2014/01/11") }, new Sale { OrderId = 10532, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 4860, Date = DateTime.Parse("2014/01/12") }, new Sale { OrderId = 10533, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 4695, Date = DateTime.Parse("2014/01/16") }, new Sale { OrderId = 10534, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 610, Date = DateTime.Parse("2014/01/05") }, new Sale { OrderId = 10535, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 1580, Date = DateTime.Parse("2014/01/15") }, new Sale { OrderId = 10536, Region = "North America", Country = "United States", City = "New York", Amount = 3780, Date = DateTime.Parse("2014/02/18") }, new Sale { OrderId = 10537, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 5400, Date = DateTime.Parse("2014/02/21") }, new Sale { OrderId = 10538, Region = "North America", Country = "United States", City = "Denver", Amount = 630, Date = DateTime.Parse("2014/02/18") }, new Sale { OrderId = 10539, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 3960, Date = DateTime.Parse("2014/02/04") }, new Sale { OrderId = 10540, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 2010, Date = DateTime.Parse("2014/02/25") }, new Sale { OrderId = 10541, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 5000, Date = DateTime.Parse("2014/02/01") }, new Sale { OrderId = 10542, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 1995, Date = DateTime.Parse("2014/02/20") }, new Sale { OrderId = 10543, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 860, Date = DateTime.Parse("2014/02/12") }, new Sale { OrderId = 10544, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 2150, Date = DateTime.Parse("2014/02/10") }, new Sale { OrderId = 10545, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 4050, Date = DateTime.Parse("2014/02/06") }, new Sale { OrderId = 10546, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 2960, Date = DateTime.Parse("2014/02/18") }, new Sale { OrderId = 10547, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 1780, Date = DateTime.Parse("2014/02/26") }, new Sale { OrderId = 10548, Region = "Asia", Country = "China", City = "Beijing", Amount = 8700, Date = DateTime.Parse("2014/02/03") }, new Sale { OrderId = 10549, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 3390, Date = DateTime.Parse("2014/02/03") }, new Sale { OrderId = 10550, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 4425, Date = DateTime.Parse("2014/02/15") }, new Sale { OrderId = 10551, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 1180, Date = DateTime.Parse("2014/02/23") }, new Sale { OrderId = 10552, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 360, Date = DateTime.Parse("2014/02/08") }, new Sale { OrderId = 10553, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 2310, Date = DateTime.Parse("2014/02/13") }, new Sale { OrderId = 10554, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 1770, Date = DateTime.Parse("2014/02/20") }, new Sale { OrderId = 10555, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 3060, Date = DateTime.Parse("2014/02/26") }, new Sale { OrderId = 10556, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 1750, Date = DateTime.Parse("2014/02/12") }, new Sale { OrderId = 10557, Region = "North America", Country = "United States", City = "New York", Amount = 2280, Date = DateTime.Parse("2014/03/09") }, new Sale { OrderId = 10558, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 7600, Date = DateTime.Parse("2014/03/25") }, new Sale { OrderId = 10559, Region = "North America", Country = "United States", City = "Denver", Amount = 1035, Date = DateTime.Parse("2014/03/23") }, new Sale { OrderId = 10560, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 1245, Date = DateTime.Parse("2014/03/01") }, new Sale { OrderId = 10561, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 2860, Date = DateTime.Parse("2014/03/19") }, new Sale { OrderId = 10562, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 440, Date = DateTime.Parse("2014/03/19") }, new Sale { OrderId = 10563, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 4665, Date = DateTime.Parse("2014/03/02") }, new Sale { OrderId = 10564, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 2270, Date = DateTime.Parse("2014/03/15") }, new Sale { OrderId = 10565, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 5000, Date = DateTime.Parse("2014/03/09") }, new Sale { OrderId = 10566, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 5100, Date = DateTime.Parse("2014/03/23") }, new Sale { OrderId = 10567, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 2120, Date = DateTime.Parse("2014/03/11") }, new Sale { OrderId = 10568, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 5140, Date = DateTime.Parse("2014/03/05") }, new Sale { OrderId = 10569, Region = "Asia", Country = "China", City = "Beijing", Amount = 6210, Date = DateTime.Parse("2014/03/19") }, new Sale { OrderId = 10570, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 9510, Date = DateTime.Parse("2014/03/19") }, new Sale { OrderId = 10571, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 7600, Date = DateTime.Parse("2014/03/21") }, new Sale { OrderId = 10572, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 5420, Date = DateTime.Parse("2014/03/15") }, new Sale { OrderId = 10573, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 1980, Date = DateTime.Parse("2014/03/05") }, new Sale { OrderId = 10574, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 1820, Date = DateTime.Parse("2014/03/07") }, new Sale { OrderId = 10575, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 1670, Date = DateTime.Parse("2014/03/21") }, new Sale { OrderId = 10576, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 4800, Date = DateTime.Parse("2014/03/08") }, new Sale { OrderId = 10577, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 2925, Date = DateTime.Parse("2014/03/03") }, new Sale { OrderId = 10578, Region = "North America", Country = "United States", City = "New York", Amount = 2940, Date = DateTime.Parse("2014/04/11") }, new Sale { OrderId = 10579, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 3525, Date = DateTime.Parse("2014/04/13") }, new Sale { OrderId = 10580, Region = "North America", Country = "United States", City = "Denver", Amount = 2475, Date = DateTime.Parse("2014/04/22") }, new Sale { OrderId = 10581, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 3315, Date = DateTime.Parse("2014/04/08") }, new Sale { OrderId = 10582, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 3140, Date = DateTime.Parse("2014/04/07") }, new Sale { OrderId = 10583, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 2520, Date = DateTime.Parse("2014/04/01") }, new Sale { OrderId = 10584, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 1200, Date = DateTime.Parse("2014/04/10") }, new Sale { OrderId = 10585, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 2060, Date = DateTime.Parse("2014/04/21") }, new Sale { OrderId = 10586, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 7875, Date = DateTime.Parse("2014/04/02") }, new Sale { OrderId = 10587, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 1450, Date = DateTime.Parse("2014/04/07") }, new Sale { OrderId = 10588, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 2640, Date = DateTime.Parse("2014/04/22") }, new Sale { OrderId = 10589, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 1960, Date = DateTime.Parse("2014/04/16") }, new Sale { OrderId = 10590, Region = "Asia", Country = "China", City = "Beijing", Amount = 2250, Date = DateTime.Parse("2014/04/23") }, new Sale { OrderId = 10591, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 4500, Date = DateTime.Parse("2014/04/05") }, new Sale { OrderId = 10592, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 5050, Date = DateTime.Parse("2014/04/11") }, new Sale { OrderId = 10593, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 2940, Date = DateTime.Parse("2014/04/02") }, new Sale { OrderId = 10594, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 2880, Date = DateTime.Parse("2014/04/14") }, new Sale { OrderId = 10595, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 1050, Date = DateTime.Parse("2014/04/19") }, new Sale { OrderId = 10596, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 1850, Date = DateTime.Parse("2014/04/02") }, new Sale { OrderId = 10597, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 3160, Date = DateTime.Parse("2014/04/01") }, new Sale { OrderId = 10598, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 875, Date = DateTime.Parse("2014/04/04") }, new Sale { OrderId = 10599, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 3200, Date = DateTime.Parse("2014/04/08") }, new Sale { OrderId = 10600, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 1380, Date = DateTime.Parse("2014/04/21") }, new Sale { OrderId = 10601, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 3060, Date = DateTime.Parse("2014/04/06") }, new Sale { OrderId = 10602, Region = "North America", Country = "United States", City = "New York", Amount = 6690, Date = DateTime.Parse("2014/05/19") }, new Sale { OrderId = 10603, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 4525, Date = DateTime.Parse("2014/05/15") }, new Sale { OrderId = 10604, Region = "North America", Country = "United States", City = "Denver", Amount = 4665, Date = DateTime.Parse("2014/05/10") }, new Sale { OrderId = 10605, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 4530, Date = DateTime.Parse("2014/05/18") }, new Sale { OrderId = 10606, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 1330, Date = DateTime.Parse("2014/05/08") }, new Sale { OrderId = 10607, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 1720, Date = DateTime.Parse("2014/05/20") }, new Sale { OrderId = 10608, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 3750, Date = DateTime.Parse("2014/05/16") }, new Sale { OrderId = 10609, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 1290, Date = DateTime.Parse("2014/05/10") }, new Sale { OrderId = 10610, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 4925, Date = DateTime.Parse("2014/05/14") }, new Sale { OrderId = 10611, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 4300, Date = DateTime.Parse("2014/05/22") }, new Sale { OrderId = 10612, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 5740, Date = DateTime.Parse("2014/05/08") }, new Sale { OrderId = 10613, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 3760, Date = DateTime.Parse("2014/05/18") }, new Sale { OrderId = 10614, Region = "Asia", Country = "China", City = "Beijing", Amount = 7920, Date = DateTime.Parse("2014/05/22") }, new Sale { OrderId = 10615, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 1440, Date = DateTime.Parse("2014/05/21") }, new Sale { OrderId = 10616, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 5975, Date = DateTime.Parse("2014/05/25") }, new Sale { OrderId = 10617, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 4440, Date = DateTime.Parse("2014/05/05") }, new Sale { OrderId = 10618, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 2310, Date = DateTime.Parse("2014/05/24") }, new Sale { OrderId = 10619, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 2250, Date = DateTime.Parse("2014/05/06") }, new Sale { OrderId = 10620, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 2320, Date = DateTime.Parse("2014/05/14") }, new Sale { OrderId = 10621, Region = "Asia", Country = "China", City = "Beijing", Amount = 8370, Date = DateTime.Parse("2014/05/06") }, new Sale { OrderId = 10622, Region = "North America", Country = "United States", City = "New York", Amount = 5190, Date = DateTime.Parse("2014/06/26") }, new Sale { OrderId = 10623, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 925, Date = DateTime.Parse("2014/06/04") }, new Sale { OrderId = 10624, Region = "North America", Country = "United States", City = "Denver", Amount = 3240, Date = DateTime.Parse("2014/06/20") }, new Sale { OrderId = 10625, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 3180, Date = DateTime.Parse("2014/06/23") }, new Sale { OrderId = 10626, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 780, Date = DateTime.Parse("2014/06/13") }, new Sale { OrderId = 10627, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 4680, Date = DateTime.Parse("2014/06/08") }, new Sale { OrderId = 10628, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 2475, Date = DateTime.Parse("2014/06/25") }, new Sale { OrderId = 10629, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 1920, Date = DateTime.Parse("2014/06/20") }, new Sale { OrderId = 10630, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 7500, Date = DateTime.Parse("2014/06/25") }, new Sale { OrderId = 10631, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 5025, Date = DateTime.Parse("2014/06/26") }, new Sale { OrderId = 10632, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 2400, Date = DateTime.Parse("2014/06/08") }, new Sale { OrderId = 10633, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 1720, Date = DateTime.Parse("2014/06/09") }, new Sale { OrderId = 10634, Region = "Asia", Country = "China", City = "Beijing", Amount = 2880, Date = DateTime.Parse("2014/06/21") }, new Sale { OrderId = 10635, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 5430, Date = DateTime.Parse("2014/06/03") }, new Sale { OrderId = 10636, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 4475, Date = DateTime.Parse("2014/06/19") }, new Sale { OrderId = 10637, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 1420, Date = DateTime.Parse("2014/06/20") }, new Sale { OrderId = 10638, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 2670, Date = DateTime.Parse("2014/06/25") }, new Sale { OrderId = 10639, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 1930, Date = DateTime.Parse("2014/06/02") }, new Sale { OrderId = 10640, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 580, Date = DateTime.Parse("2014/06/25") }, new Sale { OrderId = 10641, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 1620, Date = DateTime.Parse("2014/06/12") }, new Sale { OrderId = 10642, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 4530, Date = DateTime.Parse("2014/06/02") }, new Sale { OrderId = 10643, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 6025, Date = DateTime.Parse("2014/06/23") }, new Sale { OrderId = 10644, Region = "North America", Country = "United States", City = "New York", Amount = 3540, Date = DateTime.Parse("2014/07/21") }, new Sale { OrderId = 10645, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 3000, Date = DateTime.Parse("2014/07/01") }, new Sale { OrderId = 10646, Region = "North America", Country = "United States", City = "Denver", Amount = 3240, Date = DateTime.Parse("2014/07/26") }, new Sale { OrderId = 10647, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 2265, Date = DateTime.Parse("2014/07/22") }, new Sale { OrderId = 10648, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 400, Date = DateTime.Parse("2014/07/09") }, new Sale { OrderId = 10649, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 1460, Date = DateTime.Parse("2014/07/08") }, new Sale { OrderId = 10650, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 1620, Date = DateTime.Parse("2014/07/18") }, new Sale { OrderId = 10651, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 2400, Date = DateTime.Parse("2014/07/25") }, new Sale { OrderId = 10652, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 5275, Date = DateTime.Parse("2014/07/04") }, new Sale { OrderId = 10653, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 4475, Date = DateTime.Parse("2014/07/03") }, new Sale { OrderId = 10654, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 3980, Date = DateTime.Parse("2014/07/21") }, new Sale { OrderId = 10655, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 5240, Date = DateTime.Parse("2014/07/11") }, new Sale { OrderId = 10656, Region = "Asia", Country = "China", City = "Beijing", Amount = 1200, Date = DateTime.Parse("2014/07/21") }, new Sale { OrderId = 10657, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 5700, Date = DateTime.Parse("2014/07/18") }, new Sale { OrderId = 10658, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 5575, Date = DateTime.Parse("2014/07/01") }, new Sale { OrderId = 10659, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 2160, Date = DateTime.Parse("2014/07/02") }, new Sale { OrderId = 10660, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 960, Date = DateTime.Parse("2014/07/09") }, new Sale { OrderId = 10661, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 1280, Date = DateTime.Parse("2014/07/04") }, new Sale { OrderId = 10662, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 1040, Date = DateTime.Parse("2014/07/02") }, new Sale { OrderId = 10663, Region = "Asia", Country = "China", City = "Beijing", Amount = 5520, Date = DateTime.Parse("2014/07/21") }, new Sale { OrderId = 10664, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 1760, Date = DateTime.Parse("2014/07/25") }, new Sale { OrderId = 10665, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 4080, Date = DateTime.Parse("2014/07/07") }, new Sale { OrderId = 10666, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 1000, Date = DateTime.Parse("2014/07/21") }, new Sale { OrderId = 10667, Region = "Asia", Country = "China", City = "Beijing", Amount = 3270, Date = DateTime.Parse("2014/07/12") }, new Sale { OrderId = 10668, Region = "North America", Country = "United States", City = "New York", Amount = 1770, Date = DateTime.Parse("2014/08/23") }, new Sale { OrderId = 10669, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 2700, Date = DateTime.Parse("2014/08/09") }, new Sale { OrderId = 10670, Region = "North America", Country = "United States", City = "Denver", Amount = 2175, Date = DateTime.Parse("2014/08/03") }, new Sale { OrderId = 10671, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 3375, Date = DateTime.Parse("2014/08/11") }, new Sale { OrderId = 10672, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 2040, Date = DateTime.Parse("2014/08/01") }, new Sale { OrderId = 10673, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 3000, Date = DateTime.Parse("2014/08/21") }, new Sale { OrderId = 10674, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 3900, Date = DateTime.Parse("2014/08/16") }, new Sale { OrderId = 10675, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 1370, Date = DateTime.Parse("2014/08/20") }, new Sale { OrderId = 10676, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 5700, Date = DateTime.Parse("2014/08/01") }, new Sale { OrderId = 10677, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 1275, Date = DateTime.Parse("2014/08/22") }, new Sale { OrderId = 10678, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 4060, Date = DateTime.Parse("2014/08/13") }, new Sale { OrderId = 10679, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 2320, Date = DateTime.Parse("2014/08/18") }, new Sale { OrderId = 10680, Region = "Asia", Country = "China", City = "Beijing", Amount = 7590, Date = DateTime.Parse("2014/08/24") }, new Sale { OrderId = 10681, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 4560, Date = DateTime.Parse("2014/08/20") }, new Sale { OrderId = 10682, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 7575, Date = DateTime.Parse("2014/08/20") }, new Sale { OrderId = 10683, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 700, Date = DateTime.Parse("2014/08/25") }, new Sale { OrderId = 10684, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 2400, Date = DateTime.Parse("2014/08/16") }, new Sale { OrderId = 10685, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 1390, Date = DateTime.Parse("2014/08/15") }, new Sale { OrderId = 10686, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 1320, Date = DateTime.Parse("2014/08/09") }, new Sale { OrderId = 10687, Region = "North America", Country = "United States", City = "Denver", Amount = 1680, Date = DateTime.Parse("2014/08/09") }, new Sale { OrderId = 10688, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 1500, Date = DateTime.Parse("2014/08/11") }, new Sale { OrderId = 10689, Region = "North America", Country = "United States", City = "New York", Amount = 6150, Date = DateTime.Parse("2014/09/21") }, new Sale { OrderId = 10690, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 3675, Date = DateTime.Parse("2014/09/02") }, new Sale { OrderId = 10691, Region = "North America", Country = "United States", City = "Denver", Amount = 2250, Date = DateTime.Parse("2014/09/05") }, new Sale { OrderId = 10692, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 3585, Date = DateTime.Parse("2014/09/10") }, new Sale { OrderId = 10693, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 1470, Date = DateTime.Parse("2014/09/01") }, new Sale { OrderId = 10694, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 2260, Date = DateTime.Parse("2014/09/02") }, new Sale { OrderId = 10695, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 3765, Date = DateTime.Parse("2014/09/03") }, new Sale { OrderId = 10696, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 1640, Date = DateTime.Parse("2014/09/04") }, new Sale { OrderId = 10697, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 4475, Date = DateTime.Parse("2014/09/09") }, new Sale { OrderId = 10698, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 5975, Date = DateTime.Parse("2014/09/04") }, new Sale { OrderId = 10699, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 1100, Date = DateTime.Parse("2014/09/16") }, new Sale { OrderId = 10700, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 1320, Date = DateTime.Parse("2014/09/18") }, new Sale { OrderId = 10701, Region = "Asia", Country = "China", City = "Beijing", Amount = 8610, Date = DateTime.Parse("2014/09/19") }, new Sale { OrderId = 10702, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 9210, Date = DateTime.Parse("2014/09/09") }, new Sale { OrderId = 10703, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 3700, Date = DateTime.Parse("2014/09/01") }, new Sale { OrderId = 10704, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 3620, Date = DateTime.Parse("2014/09/19") }, new Sale { OrderId = 10705, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 4275, Date = DateTime.Parse("2014/09/01") }, new Sale { OrderId = 10706, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 2370, Date = DateTime.Parse("2014/09/03") }, new Sale { OrderId = 10707, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 1870, Date = DateTime.Parse("2014/09/10") }, new Sale { OrderId = 10708, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 2070, Date = DateTime.Parse("2014/09/25") }, new Sale { OrderId = 10709, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 5025, Date = DateTime.Parse("2014/09/19") }, new Sale { OrderId = 10710, Region = "North America", Country = "United States", City = "New York", Amount = 1080, Date = DateTime.Parse("2014/10/15") }, new Sale { OrderId = 10711, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 1400, Date = DateTime.Parse("2014/10/22") }, new Sale { OrderId = 10712, Region = "North America", Country = "United States", City = "Denver", Amount = 4260, Date = DateTime.Parse("2014/10/01") }, new Sale { OrderId = 10713, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 2745, Date = DateTime.Parse("2014/10/01") }, new Sale { OrderId = 10714, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 2920, Date = DateTime.Parse("2014/10/23") }, new Sale { OrderId = 10715, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 3520, Date = DateTime.Parse("2014/10/11") }, new Sale { OrderId = 10716, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 4035, Date = DateTime.Parse("2014/10/20") }, new Sale { OrderId = 10717, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 1730, Date = DateTime.Parse("2014/10/05") }, new Sale { OrderId = 10718, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 975, Date = DateTime.Parse("2014/10/06") }, new Sale { OrderId = 10719, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 5700, Date = DateTime.Parse("2014/10/06") }, new Sale { OrderId = 10720, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 5080, Date = DateTime.Parse("2014/10/18") }, new Sale { OrderId = 10721, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 2940, Date = DateTime.Parse("2014/10/24") }, new Sale { OrderId = 10722, Region = "Asia", Country = "China", City = "Beijing", Amount = 2670, Date = DateTime.Parse("2014/10/04") }, new Sale { OrderId = 10723, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 1230, Date = DateTime.Parse("2014/10/11") }, new Sale { OrderId = 10724, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 600, Date = DateTime.Parse("2014/10/08") }, new Sale { OrderId = 10725, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 3700, Date = DateTime.Parse("2014/10/08") }, new Sale { OrderId = 10726, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 3375, Date = DateTime.Parse("2014/10/11") }, new Sale { OrderId = 10727, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 1500, Date = DateTime.Parse("2014/10/17") }, new Sale { OrderId = 10728, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 370, Date = DateTime.Parse("2014/10/05") }, new Sale { OrderId = 10729, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 2340, Date = DateTime.Parse("2014/10/16") }, new Sale { OrderId = 10730, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 1080, Date = DateTime.Parse("2014/10/08") }, new Sale { OrderId = 10731, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 2775, Date = DateTime.Parse("2014/10/21") }, new Sale { OrderId = 10732, Region = "North America", Country = "United States", City = "New York", Amount = 4380, Date = DateTime.Parse("2014/11/09") }, new Sale { OrderId = 10733, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 5500, Date = DateTime.Parse("2014/11/21") }, new Sale { OrderId = 10734, Region = "North America", Country = "United States", City = "Denver", Amount = 1920, Date = DateTime.Parse("2014/11/24") }, new Sale { OrderId = 10735, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 765, Date = DateTime.Parse("2014/11/24") }, new Sale { OrderId = 10736, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 370, Date = DateTime.Parse("2014/11/18") }, new Sale { OrderId = 10737, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 3500, Date = DateTime.Parse("2014/11/25") }, new Sale { OrderId = 10738, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 825, Date = DateTime.Parse("2014/11/09") }, new Sale { OrderId = 10739, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 490, Date = DateTime.Parse("2014/11/23") }, new Sale { OrderId = 10740, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 7075, Date = DateTime.Parse("2014/11/20") }, new Sale { OrderId = 10741, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 1350, Date = DateTime.Parse("2014/11/25") }, new Sale { OrderId = 10742, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 1440, Date = DateTime.Parse("2014/11/15") }, new Sale { OrderId = 10743, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 2820, Date = DateTime.Parse("2014/11/13") }, new Sale { OrderId = 10744, Region = "Asia", Country = "China", City = "Beijing", Amount = 2280, Date = DateTime.Parse("2014/11/12") }, new Sale { OrderId = 10745, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 1110, Date = DateTime.Parse("2014/11/03") }, new Sale { OrderId = 10746, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 1150, Date = DateTime.Parse("2014/11/23") }, new Sale { OrderId = 10747, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 2040, Date = DateTime.Parse("2014/11/20") }, new Sale { OrderId = 10748, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 3090, Date = DateTime.Parse("2014/11/24") }, new Sale { OrderId = 10749, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 1940, Date = DateTime.Parse("2014/11/24") }, new Sale { OrderId = 10750, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 3090, Date = DateTime.Parse("2014/11/16") }, new Sale { OrderId = 10751, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 4900, Date = DateTime.Parse("2014/11/05") }, new Sale { OrderId = 10752, Region = "North America", Country = "United States", City = "Denver", Amount = 3465, Date = DateTime.Parse("2014/11/07") }, new Sale { OrderId = 10753, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 1110, Date = DateTime.Parse("2014/11/20") }, new Sale { OrderId = 10754, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 1650, Date = DateTime.Parse("2014/11/02") }, new Sale { OrderId = 10755, Region = "North America", Country = "United States", City = "New York", Amount = 5280, Date = DateTime.Parse("2014/12/04") }, new Sale { OrderId = 10756, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 3075, Date = DateTime.Parse("2014/12/02") }, new Sale { OrderId = 10757, Region = "North America", Country = "United States", City = "Denver", Amount = 690, Date = DateTime.Parse("2014/12/07") }, new Sale { OrderId = 10758, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 1305, Date = DateTime.Parse("2014/12/15") }, new Sale { OrderId = 10759, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 1970, Date = DateTime.Parse("2014/12/01") }, new Sale { OrderId = 10760, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 3760, Date = DateTime.Parse("2014/12/18") }, new Sale { OrderId = 10761, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 1920, Date = DateTime.Parse("2014/12/22") }, new Sale { OrderId = 10762, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 1360, Date = DateTime.Parse("2014/12/12") }, new Sale { OrderId = 10763, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 2525, Date = DateTime.Parse("2014/12/06") }, new Sale { OrderId = 10764, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 5575, Date = DateTime.Parse("2014/12/20") }, new Sale { OrderId = 10765, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 5560, Date = DateTime.Parse("2014/12/10") }, new Sale { OrderId = 10766, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 4880, Date = DateTime.Parse("2014/12/13") }, new Sale { OrderId = 10767, Region = "Asia", Country = "China", City = "Beijing", Amount = 8850, Date = DateTime.Parse("2014/12/03") }, new Sale { OrderId = 10768, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 2820, Date = DateTime.Parse("2014/12/10") }, new Sale { OrderId = 10769, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 4000, Date = DateTime.Parse("2014/12/12") }, new Sale { OrderId = 10770, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 5820, Date = DateTime.Parse("2014/12/02") }, new Sale { OrderId = 10771, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 1275, Date = DateTime.Parse("2014/12/12") }, new Sale { OrderId = 10772, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 1310, Date = DateTime.Parse("2014/12/01") }, new Sale { OrderId = 10773, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 2180, Date = DateTime.Parse("2014/12/26") }, new Sale { OrderId = 10774, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 4470, Date = DateTime.Parse("2014/12/17") }, new Sale { OrderId = 10775, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 2990, Date = DateTime.Parse("2014/12/15") }, new Sale { OrderId = 10776, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 7650, Date = DateTime.Parse("2014/12/18") }, new Sale { OrderId = 10777, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 780, Date = DateTime.Parse("2014/12/02") }, new Sale { OrderId = 10778, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 2970, Date = DateTime.Parse("2014/12/13") }, new Sale { OrderId = 10779, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 1155, Date = DateTime.Parse("2014/12/05") }, new Sale { OrderId = 10780, Region = "North America", Country = "United States", City = "New York", Amount = 4470, Date = DateTime.Parse("2015/01/10") }, new Sale { OrderId = 10781, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 1125, Date = DateTime.Parse("2015/01/21") }, new Sale { OrderId = 10782, Region = "North America", Country = "United States", City = "Denver", Amount = 645, Date = DateTime.Parse("2015/01/17") }, new Sale { OrderId = 10783, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 675, Date = DateTime.Parse("2015/01/05") }, new Sale { OrderId = 10784, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 2840, Date = DateTime.Parse("2015/01/05") }, new Sale { OrderId = 10785, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 2660, Date = DateTime.Parse("2015/01/04") }, new Sale { OrderId = 10786, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 4560, Date = DateTime.Parse("2015/01/12") }, new Sale { OrderId = 10787, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 2880, Date = DateTime.Parse("2015/01/20") }, new Sale { OrderId = 10788, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 500, Date = DateTime.Parse("2015/01/02") }, new Sale { OrderId = 10789, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 3925, Date = DateTime.Parse("2015/01/07") }, new Sale { OrderId = 10790, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 5660, Date = DateTime.Parse("2015/01/18") }, new Sale { OrderId = 10791, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 1460, Date = DateTime.Parse("2015/01/22") }, new Sale { OrderId = 10792, Region = "Asia", Country = "China", City = "Beijing", Amount = 5040, Date = DateTime.Parse("2015/01/10") }, new Sale { OrderId = 10793, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 4830, Date = DateTime.Parse("2015/01/13") }, new Sale { OrderId = 10794, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 3075, Date = DateTime.Parse("2015/01/22") }, new Sale { OrderId = 10795, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 3120, Date = DateTime.Parse("2015/01/14") }, new Sale { OrderId = 10796, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 3525, Date = DateTime.Parse("2015/01/23") }, new Sale { OrderId = 10797, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 1930, Date = DateTime.Parse("2015/01/09") }, new Sale { OrderId = 10798, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 2890, Date = DateTime.Parse("2015/01/02") }, new Sale { OrderId = 10799, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 1545, Date = DateTime.Parse("2015/01/17") }, new Sale { OrderId = 10800, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 3630, Date = DateTime.Parse("2015/01/20") }, new Sale { OrderId = 10801, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 4035, Date = DateTime.Parse("2015/01/14") }, new Sale { OrderId = 10802, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 345, Date = DateTime.Parse("2015/01/06") }, new Sale { OrderId = 10803, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 7000, Date = DateTime.Parse("2015/01/07") }, new Sale { OrderId = 10804, Region = "North America", Country = "United States", City = "New York", Amount = 3060, Date = DateTime.Parse("2015/02/13") }, new Sale { OrderId = 10805, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 6425, Date = DateTime.Parse("2015/02/04") }, new Sale { OrderId = 10806, Region = "North America", Country = "United States", City = "Denver", Amount = 615, Date = DateTime.Parse("2015/02/22") }, new Sale { OrderId = 10807, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 1755, Date = DateTime.Parse("2015/02/07") }, new Sale { OrderId = 10808, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 1540, Date = DateTime.Parse("2015/02/21") }, new Sale { OrderId = 10809, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 2820, Date = DateTime.Parse("2015/02/24") }, new Sale { OrderId = 10810, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 4305, Date = DateTime.Parse("2015/02/10") }, new Sale { OrderId = 10811, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 1520, Date = DateTime.Parse("2015/02/26") }, new Sale { OrderId = 10812, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 4725, Date = DateTime.Parse("2015/02/18") }, new Sale { OrderId = 10813, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 6750, Date = DateTime.Parse("2015/02/16") }, new Sale { OrderId = 10814, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 5540, Date = DateTime.Parse("2015/02/07") }, new Sale { OrderId = 10815, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 1880, Date = DateTime.Parse("2015/02/24") }, new Sale { OrderId = 10816, Region = "Asia", Country = "China", City = "Beijing", Amount = 6180, Date = DateTime.Parse("2015/02/26") }, new Sale { OrderId = 10817, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 9300, Date = DateTime.Parse("2015/02/03") }, new Sale { OrderId = 10818, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 3700, Date = DateTime.Parse("2015/02/26") }, new Sale { OrderId = 10819, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 740, Date = DateTime.Parse("2015/02/01") }, new Sale { OrderId = 10820, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 4755, Date = DateTime.Parse("2015/02/23") }, new Sale { OrderId = 10821, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 2570, Date = DateTime.Parse("2015/02/20") }, new Sale { OrderId = 10822, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 2860, Date = DateTime.Parse("2015/02/19") }, new Sale { OrderId = 10823, Region = "North America", Country = "United States", City = "New York", Amount = 5430, Date = DateTime.Parse("2015/03/21") }, new Sale { OrderId = 10824, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 4525, Date = DateTime.Parse("2015/03/21") }, new Sale { OrderId = 10825, Region = "North America", Country = "United States", City = "Denver", Amount = 1515, Date = DateTime.Parse("2015/03/10") }, new Sale { OrderId = 10826, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 630, Date = DateTime.Parse("2015/03/15") }, new Sale { OrderId = 10827, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 1310, Date = DateTime.Parse("2015/03/01") }, new Sale { OrderId = 10828, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 3200, Date = DateTime.Parse("2015/03/17") }, new Sale { OrderId = 10829, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 3945, Date = DateTime.Parse("2015/03/20") }, new Sale { OrderId = 10830, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 2990, Date = DateTime.Parse("2015/03/18") }, new Sale { OrderId = 10831, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 1125, Date = DateTime.Parse("2015/03/22") }, new Sale { OrderId = 10832, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 7950, Date = DateTime.Parse("2015/03/17") }, new Sale { OrderId = 10833, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 2960, Date = DateTime.Parse("2015/03/25") }, new Sale { OrderId = 10834, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 6300, Date = DateTime.Parse("2015/03/20") }, new Sale { OrderId = 10835, Region = "Asia", Country = "China", City = "Beijing", Amount = 8670, Date = DateTime.Parse("2015/03/07") }, new Sale { OrderId = 10836, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 3930, Date = DateTime.Parse("2015/03/23") }, new Sale { OrderId = 10837, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 6975, Date = DateTime.Parse("2015/03/02") }, new Sale { OrderId = 10838, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 4220, Date = DateTime.Parse("2015/03/17") }, new Sale { OrderId = 10839, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 3090, Date = DateTime.Parse("2015/03/25") }, new Sale { OrderId = 10840, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 2380, Date = DateTime.Parse("2015/03/01") }, new Sale { OrderId = 10841, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 1510, Date = DateTime.Parse("2015/03/07") }, new Sale { OrderId = 10842, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 1020, Date = DateTime.Parse("2015/03/19") }, new Sale { OrderId = 10843, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 6700, Date = DateTime.Parse("2015/03/26") }, new Sale { OrderId = 10844, Region = "North America", Country = "United States", City = "New York", Amount = 4890, Date = DateTime.Parse("2015/04/02") }, new Sale { OrderId = 10845, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 7225, Date = DateTime.Parse("2015/04/13") }, new Sale { OrderId = 10846, Region = "North America", Country = "United States", City = "Denver", Amount = 795, Date = DateTime.Parse("2015/04/07") }, new Sale { OrderId = 10847, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 1785, Date = DateTime.Parse("2015/04/03") }, new Sale { OrderId = 10848, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 1850, Date = DateTime.Parse("2015/04/03") }, new Sale { OrderId = 10849, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 5120, Date = DateTime.Parse("2015/04/12") }, new Sale { OrderId = 10850, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 615, Date = DateTime.Parse("2015/04/07") }, new Sale { OrderId = 10851, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 2860, Date = DateTime.Parse("2015/04/05") }, new Sale { OrderId = 10852, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 1525, Date = DateTime.Parse("2015/04/24") }, new Sale { OrderId = 10853, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 7425, Date = DateTime.Parse("2015/04/15") }, new Sale { OrderId = 10854, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 6080, Date = DateTime.Parse("2015/04/13") }, new Sale { OrderId = 10855, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 2940, Date = DateTime.Parse("2015/04/04") }, new Sale { OrderId = 10856, Region = "Asia", Country = "China", City = "Beijing", Amount = 5580, Date = DateTime.Parse("2015/04/16") }, new Sale { OrderId = 10857, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 9390, Date = DateTime.Parse("2015/04/19") }, new Sale { OrderId = 10858, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 3200, Date = DateTime.Parse("2015/04/26") }, new Sale { OrderId = 10859, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 4380, Date = DateTime.Parse("2015/04/05") }, new Sale { OrderId = 10860, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 4725, Date = DateTime.Parse("2015/04/06") }, new Sale { OrderId = 10861, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 930, Date = DateTime.Parse("2015/04/25") }, new Sale { OrderId = 10862, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 1910, Date = DateTime.Parse("2015/04/05") }, new Sale { OrderId = 10863, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 2725, Date = DateTime.Parse("2015/04/16") }, new Sale { OrderId = 10864, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 4720, Date = DateTime.Parse("2015/04/02") }, new Sale { OrderId = 10865, Region = "Asia", Country = "China", City = "Beijing", Amount = 5190, Date = DateTime.Parse("2015/04/10") }, new Sale { OrderId = 10866, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 2800, Date = DateTime.Parse("2015/04/26") }, new Sale { OrderId = 10867, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 3780, Date = DateTime.Parse("2015/04/24") }, new Sale { OrderId = 10868, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 2340, Date = DateTime.Parse("2015/04/17") }, new Sale { OrderId = 10869, Region = "North America", Country = "United States", City = "New York", Amount = 4830, Date = DateTime.Parse("2015/05/12") }, new Sale { OrderId = 10870, Region = "North America", Country = "United States", City = "Los Angeles", Amount = 2075, Date = DateTime.Parse("2015/05/23") }, new Sale { OrderId = 10871, Region = "North America", Country = "United States", City = "Denver", Amount = 3420, Date = DateTime.Parse("2015/05/21") }, new Sale { OrderId = 10872, Region = "North America", Country = "Canada", City = "Vancouver", Amount = 1440, Date = DateTime.Parse("2015/05/10") }, new Sale { OrderId = 10873, Region = "North America", Country = "Canada", City = "Edmonton", Amount = 1680, Date = DateTime.Parse("2015/05/15") }, new Sale { OrderId = 10874, Region = "South America", Country = "Brazil", City = "Rio de Janeiro", Amount = 3440, Date = DateTime.Parse("2015/05/16") }, new Sale { OrderId = 10875, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 4695, Date = DateTime.Parse("2015/05/10") }, new Sale { OrderId = 10876, Region = "South America", Country = "Paraguay", City = "Asuncion", Amount = 2380, Date = DateTime.Parse("2015/05/06") }, new Sale { OrderId = 10877, Region = "Europe", Country = "United Kingdom", City = "London", Amount = 1875, Date = DateTime.Parse("2015/05/25") }, new Sale { OrderId = 10878, Region = "Europe", Country = "Germany", City = "Berlin", Amount = 7550, Date = DateTime.Parse("2015/05/14") }, new Sale { OrderId = 10879, Region = "Europe", Country = "Spain", City = "Madrid", Amount = 3340, Date = DateTime.Parse("2015/05/01") }, new Sale { OrderId = 10880, Region = "Europe", Country = "Russian Federation", City = "Moscow", Amount = 1400, Date = DateTime.Parse("2015/05/22") }, new Sale { OrderId = 10881, Region = "Asia", Country = "China", City = "Beijing", Amount = 6060, Date = DateTime.Parse("2015/05/22") }, new Sale { OrderId = 10882, Region = "Asia", Country = "Japan", City = "Tokyo", Amount = 8370, Date = DateTime.Parse("2015/05/13") }, new Sale { OrderId = 10883, Region = "Asia", Country = "Republic of Korea", City = "Seoul", Amount = 3550, Date = DateTime.Parse("2015/05/26") }, new Sale { OrderId = 10884, Region = "Australia", Country = "Australia", City = "Sydney", Amount = 2620, Date = DateTime.Parse("2015/05/17") }, new Sale { OrderId = 10885, Region = "Australia", Country = "Australia", City = "Melbourne", Amount = 2400, Date = DateTime.Parse("2015/05/21") }, new Sale { OrderId = 10886, Region = "Africa", Country = "South Africa", City = "Pretoria", Amount = 1740, Date = DateTime.Parse("2015/05/21") }, new Sale { OrderId = 10887, Region = "Africa", Country = "Egypt", City = "Cairo", Amount = 500, Date = DateTime.Parse("2015/05/26") }, new Sale { OrderId = 10888, Region = "South America", Country = "Argentina", City = "Buenos Aires", Amount = 780, Date = DateTime.Parse("2015/05/07") } }; } }
#pivotgrid { margin-top: 20px; } .currency { text-align: center; }

Bind the Chart to the PivotGrid

To bind these two components, create a Chart and pass its instance as the first argument to the PivotGrid's bindChart(chart, integrationOptions) method. You can call this method at any point in your application. In this demo, we call it after view is initialized / component is mounted.

If you specify only the first argument and omit integrationOptions, default settings are in effect: row and column field values constitute chart series and arguments, respectively. The Chart displays values of each data field on a separate value axis. If you need to customize the resulting chart, specify the integrationOptions argument.

Convert PivotGrid Fields to Chart Series

You can use the following integrationOptions to specify how PivotGrid fields should be converted to chart series:

  • putDataFieldsInto: "series" | "args"

    • "series" - Data fields constitute chart series.
    • "args" - Data fields constitute chart arguments.
  • alternateDataFields: Boolean
    Specifies whether to alternate data fields in the resulting chart. This demo sets this field to false.

  • dataFieldsDisplayMode: "singleAxis" | "splitAxes" | "splitPanes"

    • "singleAxis" - All data field values are displayed on a single value axis.
    • "splitAxes" - Each data field has an individual value axis. Applies only if putDataFieldsInto is "series".
    • "splitPanes" - Each data field has an individual pane. Applies only if putDataFieldsInto is "series".

    dataFieldsDisplayMode applies only if the PivotGrid contains several data fields. In this demo, the dataFieldsDisplayMode field is set to "splitPanes".

  • inverted: Boolean
    If false, row field values constitute series and column field values form the chart arguments. If true - vice versa.

Advanced Customization

The integrationOptions object can also contain the following functions that allow you to process PivotGrid data before visualization and customize the Chart and its series:

  • processCell
    Processes a PivotGrid cell's data before the Chart displays it.

  • customizeChart
    Allows you to customize the Chart's appearance.

  • customizeSeries
    Allows you to customize the Chart's series.

Refer to the bindChart(chart, integrationOptions) method description for more information on these functions.