Your search did not match any results.

Standalone Field Chooser

DevExtreme includes a standalone PivotGridFieldChooser component. Unlike its integrated counterpart, the standalone field chooser can remain visible on the page at all times.

Backend API
@using DevExtreme.NETCore.Demos.Models @(Html.DevExtreme().PivotGrid<Sale>() .ID("sales") .AllowSortingBySummary(true) .AllowSorting(true) .AllowFiltering(true) .ShowBorders(true) .DataSource(d => d .Store(s => s.Mvc().Controller("PivotGridData").LoadAction("Get")) .Fields(fields => { fields.AddFor(m => m.Region) .Width(120) .Area(PivotGridArea.Row) .HeaderFilter(hf => hf.Search(hfs => hfs.Enabled(true))); fields.AddFor(m => m.City) .Width(150) .Area(PivotGridArea.Row) .HeaderFilter(hf => hf.Search(hfs => hfs.Enabled(true))) .Selector("pivotGrid_dataSource_cityField_selector"); fields.AddFor(m => m.Date) .Area(PivotGridArea.Column); fields.AddFor(m => m.Amount) .Caption("Sales") .Area(PivotGridArea.Data) .SummaryType(SummaryType.Sum) .Format(Format.Currency); }) ) .FieldChooser(fc => fc.Enabled(false)) ) <div class="container"> <div id="sales-fieldchooser"></div> <div class="bottom-bar"> @(Html.DevExtreme().Button() .ID("applyButton") .Text("Apply") .Type(ButtonType.Default) .Visible(false) .OnClick("applyButton_onClick") ) @(Html.DevExtreme().Button() .ID("cancelButton") .Text("Cancel") .Visible(false) .OnClick("cancelButton_onClick") ) </div> <div class="options"> <div class="caption">Options</div> <div class="option"> <span>Choose layout:</span> @(Html.DevExtreme().RadioGroup() .ID("layouts") .DataSource(Model) .Layout(Orientation.Vertical) .ValueExpr("Key") .DisplayExpr("Name") .Value(PivotGridFieldChooserLayout.Layout0) .OnValueChanged("radioGroup_onValueChanged") ) </div> <div class="option"> <span>Apply Changes Mode:</span> @(Html.DevExtreme().SelectBox() .ID("applyChangesMode") .InputAttr("aria-label", "Apply Changes Mode") .DataSource(new JS("applyChangesModes")) .Width(180) .Value(new JS("applyChangesModes[0]")) .OnValueChanged("selectBox_onValueChanged") ) </div> </div> </div> <script> var applyChangesModes = ["instantly", "onDemand"]; function pivotGrid_dataSource_cityField_selector(data) { return data.City + " (" + data.Country + ")"; } function radioGroup_onValueChanged(e) { $("#sales-fieldchooser").dxPivotGridFieldChooser("instance").option("layout", e.value); } function selectBox_onValueChanged(data) { $("#sales-fieldchooser").dxPivotGridFieldChooser("instance").option("applyChangesMode", data.value); $("#applyButton").dxButton("instance").option("visible", data.value === "onDemand"); $("#cancelButton").dxButton("instance").option("visible", data.value === "onDemand"); } function applyButton_onClick(e) { $("#sales-fieldchooser").dxPivotGridFieldChooser("instance").applyChanges(); } function cancelButton_onClick(e) { $("#sales-fieldchooser").dxPivotGridFieldChooser("instance").cancelChanges(); } $(function () { $("#sales-fieldchooser").dxPivotGridFieldChooser({ dataSource: $("#sales").dxPivotGrid("instance").getDataSource(), texts: { allFields: "All", columnFields: "Columns", dataFields: "Data", rowFields: "Rows", filterFields: "Filter" }, width: 400, height: 400 }); }); </script>
using DevExtreme.NETCore.Demos.Models.SampleData; using Microsoft.AspNetCore.Mvc; using Newtonsoft.Json; using System; using System.Collections.Generic; using System.Linq; namespace DevExtreme.NETCore.Demos.Controllers { public class PivotGridController : Controller { public ActionResult StandaloneFieldChooser() { return View(SampleData.GetLayouts()); } } }
using System; using System.Collections.Generic; using System.Linq; using System.Net.Http; using DevExtreme.AspNet.Data; using DevExtreme.AspNet.Mvc; using DevExtreme.NETCore.Demos.Models.SampleData; using Microsoft.AspNetCore.Mvc; namespace DevExtreme.NETCore.Demos.Controllers.ApiControllers { [Route("api/[controller]")] public class PivotGridDataController : Controller { [HttpGet] public object Get(DataSourceLoadOptions loadOptions) { return DataSourceLoader.Load(SampleData.Sales, loadOptions); } } }
using System; using System.Collections.Generic; using System.Linq; namespace DevExtreme.NETCore.Demos.Models { public class Layout { public int Key { get; set; } public string Name { get; set; } } }
using System; using System.Collections.Generic; using System.Linq; using DevExtreme.AspNet.Mvc; namespace DevExtreme.NETCore.Demos.Models.SampleData { public partial class SampleData { public static IEnumerable<Layout> GetLayouts() { return Enum.GetNames(typeof(PivotGridFieldChooserLayout)).Select((name, index) => new Layout { Key = index, Name = name }); } } }
using System; using System.ComponentModel.DataAnnotations; namespace DevExtreme.NETCore.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.NETCore.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") } }; } }
.container { position: relative; margin-top: 20px; margin-bottom: 20px; } .bottom-bar { width: 396px; text-align: right; margin-top: 5px; } #applyButton { margin-right: 10px; } .options { padding: 20px; background-color: rgba(191, 191, 191, 0.15); position: absolute; top: 29px; bottom: 3px; left: 420px; width: 180px; } .caption { font-size: 18px; font-weight: 500; } .option { margin-top: 10px; } .option > .dx-radiogroup { margin-top: 5px; } .option > .dx-selectbox { margin-top: 5px; }

Follow the steps below to connect the PivotGridFieldChooser with the PivotGrid:

  1. Bind both components to the same data source
    Assign the same PivotGridDataSource instance to the dataSource property of both components.

  2. (Optional) Disable the integrated field chooser
    Both field choosers can work simultaneously, but if you want to disable the integrated version, set the PivotGrid's fieldChooser.enabled property to false.

  3. (Optional) Apply field changes on demand
    When users move fields within the field chooser, the changes are applied to the connected PivotGrid instantly. To change this behavior, set the applyChangesMode to "onDemand". In this mode, the changes are applied/canceled only when you call the applyChanges()/cancelChanges() method or set a new state. You can add a UI for these methods. For example, in this demo, they are bound to the Apply and Cancel buttons. Select "onDemand" from the Apply Changes Mode drop-down menu to display these buttons.

The standalone and integrated field choosers share features. For example, both field choosers include three layouts. You can use the radio buttons to switch between field choosers and review the differences. For information about other available features, refer to the Integrated Field Chooser demo.