Backend API
@using DevExtreme.NETCore.Demos.Models
@(Html.DevExtreme().PivotGrid<Sale>()
.ID("sales")
.DataFieldArea(PivotGridDataFieldArea.Column)
.RowHeaderLayout(PivotGridRowHeadersLayout.Tree)
.WordWrapEnabled(false)
.ShowBorders(true)
.Height(440)
.DataSource(d => d
.Store(s => s.Mvc().Controller("PivotGridData").LoadAction("Get"))
.Fields(fields => {
fields.AddFor(m => m.Region)
.Expanded(true)
.Area(PivotGridArea.Row);
fields.AddFor(m => m.Country)
.Expanded(true)
.Area(PivotGridArea.Row);
fields.AddFor(m => m.City)
.Area(PivotGridArea.Row);
fields.AddFor(m => m.Date)
.Area(PivotGridArea.Column);
fields.AddFor(m => m.Amount)
.Caption("Sales")
.SummaryType(SummaryType.Sum)
.Format(Format.Currency)
.Area(PivotGridArea.Data);
fields.AddFor(m => m.Amount)
.Caption("Percent")
.SummaryType(SummaryType.Sum)
.SummaryDisplayMode(PivotGridSummaryDisplayMode.PercentOfRowGrandTotal)
.Area(PivotGridArea.Data);
})
)
.FieldChooser(c => c.Height(500))
)
<div class="options">
<div class="caption">Options</div>
<div class="option">
@(Html.DevExtreme().CheckBox()
.Text("Show Totals Prior")
.Value(false)
.OnValueChanged(@<text>
function(data) {
getPivotGridInstance().option("showTotalsPrior", data.value ? "both" : "none");
}
</text>)
)
</div>
<div class="option">
@(Html.DevExtreme().CheckBox()
.Text("Data Field Headers in Rows")
.Value(false)
.OnValueChanged(@<text>
function(data) {
getPivotGridInstance().option("dataFieldArea", data.value ? "row" : "column");
}
</text>)
)
</div>
<div class="option">
@(Html.DevExtreme().CheckBox()
.Text("Tree Row Header Layout")
.Value(true)
.OnValueChanged(@<text>
function(data) {
getPivotGridInstance().option("rowHeaderLayout", data.value ? "tree" : "standard");
}
</text>)
)
</div>
</div>
<script>
function getPivotGridInstance() {
return $("#sales").dxPivotGrid("instance");
}
</script>
using DevExtreme.NETCore.Demos.Models.SampleData;
using Microsoft.AspNetCore.Mvc;
using System;
using System.Collections.Generic;
using System.Linq;
namespace DevExtreme.NETCore.Demos.Controllers {
public class PivotGridController : Controller {
public ActionResult Customization() {
return View();
}
}
}
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.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 = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 8400,
Date = DateTime.Parse("2013/01/05")
},
new Sale {
OrderId = 10260,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 1325,
Date = DateTime.Parse("2013/01/14")
},
new Sale {
OrderId = 10261,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 3920,
Date = DateTime.Parse("2013/01/05")
},
new Sale {
OrderId = 10262,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 2220,
Date = DateTime.Parse("2013/01/15")
},
new Sale {
OrderId = 10263,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 940,
Date = DateTime.Parse("2013/01/01")
},
new Sale {
OrderId = 10264,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 1630,
Date = DateTime.Parse("2013/01/10")
},
new Sale {
OrderId = 10265,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 2910,
Date = DateTime.Parse("2013/01/23")
},
new Sale {
OrderId = 10266,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 2600,
Date = DateTime.Parse("2013/01/14")
},
new Sale {
OrderId = 10267,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 4340,
Date = DateTime.Parse("2013/01/26")
},
new Sale {
OrderId = 10268,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 6650,
Date = DateTime.Parse("2013/01/24")
},
new Sale {
OrderId = 10269,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 490,
Date = DateTime.Parse("2013/01/22")
},
new Sale {
OrderId = 10270,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 3390,
Date = DateTime.Parse("2013/01/25")
},
new Sale {
OrderId = 10271,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 5160,
Date = DateTime.Parse("2013/02/20")
},
new Sale {
OrderId = 10272,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 5750,
Date = DateTime.Parse("2013/02/12")
},
new Sale {
OrderId = 10273,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 2805,
Date = DateTime.Parse("2013/02/13")
},
new Sale {
OrderId = 10274,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 2505,
Date = DateTime.Parse("2013/02/09")
},
new Sale {
OrderId = 10275,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 930,
Date = DateTime.Parse("2013/02/04")
},
new Sale {
OrderId = 10276,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 1240,
Date = DateTime.Parse("2013/02/03")
},
new Sale {
OrderId = 10277,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 315,
Date = DateTime.Parse("2013/02/04")
},
new Sale {
OrderId = 10278,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 2870,
Date = DateTime.Parse("2013/02/18")
},
new Sale {
OrderId = 10279,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 5150,
Date = DateTime.Parse("2013/02/18")
},
new Sale {
OrderId = 10280,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 2725,
Date = DateTime.Parse("2013/02/20")
},
new Sale {
OrderId = 10281,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 2840,
Date = DateTime.Parse("2013/02/04")
},
new Sale {
OrderId = 10282,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 1200,
Date = DateTime.Parse("2013/02/03")
},
new Sale {
OrderId = 10283,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 4550,
Date = DateTime.Parse("2013/02/08")
},
new Sale {
OrderId = 10284,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 6040,
Date = DateTime.Parse("2013/02/17")
},
new Sale {
OrderId = 10285,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 2205,
Date = DateTime.Parse("2013/02/08")
},
new Sale {
OrderId = 10286,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 990,
Date = DateTime.Parse("2013/02/20")
},
new Sale {
OrderId = 10287,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 700,
Date = DateTime.Parse("2013/02/11")
},
new Sale {
OrderId = 10288,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 2325,
Date = DateTime.Parse("2013/02/15")
},
new Sale {
OrderId = 10289,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 930,
Date = DateTime.Parse("2013/02/21")
},
new Sale {
OrderId = 10290,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 1560,
Date = DateTime.Parse("2013/02/04")
},
new Sale {
OrderId = 10291,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 1740,
Date = DateTime.Parse("2013/03/04")
},
new Sale {
OrderId = 10292,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 3575,
Date = DateTime.Parse("2013/03/20")
},
new Sale {
OrderId = 10293,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 4500,
Date = DateTime.Parse("2013/03/04")
},
new Sale {
OrderId = 10294,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 1605,
Date = DateTime.Parse("2013/03/17")
},
new Sale {
OrderId = 10295,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 800,
Date = DateTime.Parse("2013/03/21")
},
new Sale {
OrderId = 10296,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 640,
Date = DateTime.Parse("2013/03/08")
},
new Sale {
OrderId = 10297,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 735,
Date = DateTime.Parse("2013/03/19")
},
new Sale {
OrderId = 10298,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 2520,
Date = DateTime.Parse("2013/03/20")
},
new Sale {
OrderId = 10299,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 6675,
Date = DateTime.Parse("2013/03/18")
},
new Sale {
OrderId = 10300,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 3625,
Date = DateTime.Parse("2013/03/25")
},
new Sale {
OrderId = 10301,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 1200,
Date = DateTime.Parse("2013/03/07")
},
new Sale {
OrderId = 10302,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 2700,
Date = DateTime.Parse("2013/03/19")
},
new Sale {
OrderId = 10303,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 5950,
Date = DateTime.Parse("2013/03/24")
},
new Sale {
OrderId = 10304,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 5120,
Date = DateTime.Parse("2013/03/08")
},
new Sale {
OrderId = 10305,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 1980,
Date = DateTime.Parse("2013/03/17")
},
new Sale {
OrderId = 10306,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 1110,
Date = DateTime.Parse("2013/03/08")
},
new Sale {
OrderId = 10307,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 980,
Date = DateTime.Parse("2013/03/21")
},
new Sale {
OrderId = 10308,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 5460,
Date = DateTime.Parse("2013/03/19")
},
new Sale {
OrderId = 10309,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 3800,
Date = DateTime.Parse("2013/03/12")
},
new Sale {
OrderId = 10310,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 2610,
Date = DateTime.Parse("2013/03/04")
},
new Sale {
OrderId = 10311,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 2010,
Date = DateTime.Parse("2013/03/23")
},
new Sale {
OrderId = 10312,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 7680,
Date = DateTime.Parse("2013/04/15")
},
new Sale {
OrderId = 10313,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 1325,
Date = DateTime.Parse("2013/04/07")
},
new Sale {
OrderId = 10314,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 2835,
Date = DateTime.Parse("2013/04/10")
},
new Sale {
OrderId = 10315,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 3660,
Date = DateTime.Parse("2013/04/10")
},
new Sale {
OrderId = 10316,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 390,
Date = DateTime.Parse("2013/04/12")
},
new Sale {
OrderId = 10317,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 4420,
Date = DateTime.Parse("2013/04/08")
},
new Sale {
OrderId = 10318,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 1755,
Date = DateTime.Parse("2013/04/13")
},
new Sale {
OrderId = 10319,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 2580,
Date = DateTime.Parse("2013/04/15")
},
new Sale {
OrderId = 10320,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 850,
Date = DateTime.Parse("2013/04/01")
},
new Sale {
OrderId = 10321,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 2825,
Date = DateTime.Parse("2013/04/10")
},
new Sale {
OrderId = 10322,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 540,
Date = DateTime.Parse("2013/04/06")
},
new Sale {
OrderId = 10323,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 1110,
Date = DateTime.Parse("2013/04/16")
},
new Sale {
OrderId = 10324,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 6850,
Date = DateTime.Parse("2013/04/19")
},
new Sale {
OrderId = 10325,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 1940,
Date = DateTime.Parse("2013/04/23")
},
new Sale {
OrderId = 10326,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 1980,
Date = DateTime.Parse("2013/04/21")
},
new Sale {
OrderId = 10327,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 3090,
Date = DateTime.Parse("2013/04/03")
},
new Sale {
OrderId = 10328,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 1640,
Date = DateTime.Parse("2013/04/24")
},
new Sale {
OrderId = 10329,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 3585,
Date = DateTime.Parse("2013/04/01")
},
new Sale {
OrderId = 10330,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 1770,
Date = DateTime.Parse("2013/04/01")
},
new Sale {
OrderId = 10331,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 4005,
Date = DateTime.Parse("2013/04/04")
},
new Sale {
OrderId = 10332,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 2870,
Date = DateTime.Parse("2013/04/02")
},
new Sale {
OrderId = 10333,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 960,
Date = DateTime.Parse("2013/04/20")
},
new Sale {
OrderId = 10334,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 8640,
Date = DateTime.Parse("2013/05/14")
},
new Sale {
OrderId = 10335,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 5450,
Date = DateTime.Parse("2013/05/24")
},
new Sale {
OrderId = 10336,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 2535,
Date = DateTime.Parse("2013/05/07")
},
new Sale {
OrderId = 10337,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 1155,
Date = DateTime.Parse("2013/05/20")
},
new Sale {
OrderId = 10338,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 3140,
Date = DateTime.Parse("2013/05/18")
},
new Sale {
OrderId = 10339,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 2260,
Date = DateTime.Parse("2013/05/19")
},
new Sale {
OrderId = 10340,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 1215,
Date = DateTime.Parse("2013/05/23")
},
new Sale {
OrderId = 10341,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 1210,
Date = DateTime.Parse("2013/05/08")
},
new Sale {
OrderId = 10342,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 875,
Date = DateTime.Parse("2013/05/25")
},
new Sale {
OrderId = 10343,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 5400,
Date = DateTime.Parse("2013/05/03")
},
new Sale {
OrderId = 10344,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 5940,
Date = DateTime.Parse("2013/05/25")
},
new Sale {
OrderId = 10345,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 9210,
Date = DateTime.Parse("2013/05/22")
},
new Sale {
OrderId = 10346,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 7950,
Date = DateTime.Parse("2013/05/12")
},
new Sale {
OrderId = 10347,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 3740,
Date = DateTime.Parse("2013/05/24")
},
new Sale {
OrderId = 10348,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 990,
Date = DateTime.Parse("2013/05/02")
},
new Sale {
OrderId = 10349,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 3190,
Date = DateTime.Parse("2013/05/03")
},
new Sale {
OrderId = 10350,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 2430,
Date = DateTime.Parse("2013/05/11")
},
new Sale {
OrderId = 10351,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 7380,
Date = DateTime.Parse("2013/06/15")
},
new Sale {
OrderId = 10352,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 4475,
Date = DateTime.Parse("2013/06/08")
},
new Sale {
OrderId = 10353,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 1290,
Date = DateTime.Parse("2013/06/10")
},
new Sale {
OrderId = 10354,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 2250,
Date = DateTime.Parse("2013/06/10")
},
new Sale {
OrderId = 10355,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 350,
Date = DateTime.Parse("2013/06/22")
},
new Sale {
OrderId = 10356,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 5480,
Date = DateTime.Parse("2013/06/24")
},
new Sale {
OrderId = 10357,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 2355,
Date = DateTime.Parse("2013/06/10")
},
new Sale {
OrderId = 10358,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 1960,
Date = DateTime.Parse("2013/06/23")
},
new Sale {
OrderId = 10359,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 4125,
Date = DateTime.Parse("2013/06/06")
},
new Sale {
OrderId = 10360,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 7925,
Date = DateTime.Parse("2013/06/12")
},
new Sale {
OrderId = 10361,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 1120,
Date = DateTime.Parse("2013/06/22")
},
new Sale {
OrderId = 10362,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 5130,
Date = DateTime.Parse("2013/06/10")
},
new Sale {
OrderId = 10363,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 2475,
Date = DateTime.Parse("2013/06/10")
},
new Sale {
OrderId = 10364,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 2100,
Date = DateTime.Parse("2013/06/06")
},
new Sale {
OrderId = 10365,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 3570,
Date = DateTime.Parse("2013/06/10")
},
new Sale {
OrderId = 10366,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 550,
Date = DateTime.Parse("2013/06/02")
},
new Sale {
OrderId = 10367,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 2850,
Date = DateTime.Parse("2013/06/26")
},
new Sale {
OrderId = 10368,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 1460,
Date = DateTime.Parse("2013/06/17")
},
new Sale {
OrderId = 10369,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 960,
Date = DateTime.Parse("2013/06/17")
},
new Sale {
OrderId = 10370,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 1520,
Date = DateTime.Parse("2013/06/03")
},
new Sale {
OrderId = 10371,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 6750,
Date = DateTime.Parse("2013/06/21")
},
new Sale {
OrderId = 10372,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 7260,
Date = DateTime.Parse("2013/07/14")
},
new Sale {
OrderId = 10373,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 2450,
Date = DateTime.Parse("2013/07/11")
},
new Sale {
OrderId = 10374,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 3540,
Date = DateTime.Parse("2013/07/02")
},
new Sale {
OrderId = 10375,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 1950,
Date = DateTime.Parse("2013/07/03")
},
new Sale {
OrderId = 10376,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 360,
Date = DateTime.Parse("2013/07/07")
},
new Sale {
OrderId = 10377,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 4500,
Date = DateTime.Parse("2013/07/03")
},
new Sale {
OrderId = 10378,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 4575,
Date = DateTime.Parse("2013/07/21")
},
new Sale {
OrderId = 10379,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 2310,
Date = DateTime.Parse("2013/07/18")
},
new Sale {
OrderId = 10380,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 7500,
Date = DateTime.Parse("2013/07/04")
},
new Sale {
OrderId = 10381,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 3575,
Date = DateTime.Parse("2013/07/23")
},
new Sale {
OrderId = 10382,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 760,
Date = DateTime.Parse("2013/07/01")
},
new Sale {
OrderId = 10383,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 3480,
Date = DateTime.Parse("2013/07/23")
},
new Sale {
OrderId = 10384,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 4875,
Date = DateTime.Parse("2013/07/11")
},
new Sale {
OrderId = 10385,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 4980,
Date = DateTime.Parse("2013/07/19")
},
new Sale {
OrderId = 10386,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 2580,
Date = DateTime.Parse("2013/07/04")
},
new Sale {
OrderId = 10387,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 2650,
Date = DateTime.Parse("2013/07/16")
},
new Sale {
OrderId = 10388,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 1190,
Date = DateTime.Parse("2013/07/02")
},
new Sale {
OrderId = 10389,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 960,
Date = DateTime.Parse("2013/07/26")
},
new Sale {
OrderId = 10390,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 3600,
Date = DateTime.Parse("2013/08/08")
},
new Sale {
OrderId = 10391,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 2250,
Date = DateTime.Parse("2013/08/01")
},
new Sale {
OrderId = 10392,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 1275,
Date = DateTime.Parse("2013/08/02")
},
new Sale {
OrderId = 10393,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 3885,
Date = DateTime.Parse("2013/08/14")
},
new Sale {
OrderId = 10394,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 1900,
Date = DateTime.Parse("2013/08/05")
},
new Sale {
OrderId = 10395,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 2300,
Date = DateTime.Parse("2013/08/09")
},
new Sale {
OrderId = 10396,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 2895,
Date = DateTime.Parse("2013/08/15")
},
new Sale {
OrderId = 10397,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 350,
Date = DateTime.Parse("2013/08/20")
},
new Sale {
OrderId = 10398,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 4200,
Date = DateTime.Parse("2013/08/22")
},
new Sale {
OrderId = 10399,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 7175,
Date = DateTime.Parse("2013/08/14")
},
new Sale {
OrderId = 10400,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 4420,
Date = DateTime.Parse("2013/08/24")
},
new Sale {
OrderId = 10401,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 6990,
Date = DateTime.Parse("2013/08/22")
},
new Sale {
OrderId = 10402,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 2125,
Date = DateTime.Parse("2013/08/05")
},
new Sale {
OrderId = 10403,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 2220,
Date = DateTime.Parse("2013/08/16")
},
new Sale {
OrderId = 10404,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 1575,
Date = DateTime.Parse("2013/08/23")
},
new Sale {
OrderId = 10405,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 1880,
Date = DateTime.Parse("2013/08/12")
},
new Sale {
OrderId = 10406,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 710,
Date = DateTime.Parse("2013/08/25")
},
new Sale {
OrderId = 10407,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 390,
Date = DateTime.Parse("2013/08/20")
},
new Sale {
OrderId = 10408,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 4635,
Date = DateTime.Parse("2013/08/04")
},
new Sale {
OrderId = 10409,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 4350,
Date = DateTime.Parse("2013/08/19")
},
new Sale {
OrderId = 10410,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 6020,
Date = DateTime.Parse("2013/08/02")
},
new Sale {
OrderId = 10411,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 3660,
Date = DateTime.Parse("2013/08/19")
},
new Sale {
OrderId = 10412,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 4525,
Date = DateTime.Parse("2013/08/24")
},
new Sale {
OrderId = 10413,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 4410,
Date = DateTime.Parse("2013/09/12")
},
new Sale {
OrderId = 10414,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 1725,
Date = DateTime.Parse("2013/09/07")
},
new Sale {
OrderId = 10415,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 2715,
Date = DateTime.Parse("2013/09/14")
},
new Sale {
OrderId = 10416,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 2820,
Date = DateTime.Parse("2013/09/08")
},
new Sale {
OrderId = 10417,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 2310,
Date = DateTime.Parse("2013/09/12")
},
new Sale {
OrderId = 10418,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 780,
Date = DateTime.Parse("2013/09/08")
},
new Sale {
OrderId = 10419,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 2370,
Date = DateTime.Parse("2013/09/19")
},
new Sale {
OrderId = 10420,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 1410,
Date = DateTime.Parse("2013/09/09")
},
new Sale {
OrderId = 10421,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 1825,
Date = DateTime.Parse("2013/09/23")
},
new Sale {
OrderId = 10422,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 4075,
Date = DateTime.Parse("2013/09/06")
},
new Sale {
OrderId = 10423,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 1020,
Date = DateTime.Parse("2013/09/04")
},
new Sale {
OrderId = 10424,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 2820,
Date = DateTime.Parse("2013/09/08")
},
new Sale {
OrderId = 10425,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 3050,
Date = DateTime.Parse("2013/09/04")
},
new Sale {
OrderId = 10426,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 5080,
Date = DateTime.Parse("2013/09/25")
},
new Sale {
OrderId = 10427,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 1125,
Date = DateTime.Parse("2013/09/13")
},
new Sale {
OrderId = 10428,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 850,
Date = DateTime.Parse("2013/09/24")
},
new Sale {
OrderId = 10429,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 1440,
Date = DateTime.Parse("2013/09/19")
},
new Sale {
OrderId = 10430,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 1950,
Date = DateTime.Parse("2013/09/02")
},
new Sale {
OrderId = 10431,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 6390,
Date = DateTime.Parse("2013/10/11")
},
new Sale {
OrderId = 10432,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 4625,
Date = DateTime.Parse("2013/10/02")
},
new Sale {
OrderId = 10433,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 3510,
Date = DateTime.Parse("2013/10/24")
},
new Sale {
OrderId = 10434,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 2730,
Date = DateTime.Parse("2013/10/15")
},
new Sale {
OrderId = 10435,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 2070,
Date = DateTime.Parse("2013/10/15")
},
new Sale {
OrderId = 10436,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 2320,
Date = DateTime.Parse("2013/10/18")
},
new Sale {
OrderId = 10437,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 4260,
Date = DateTime.Parse("2013/10/24")
},
new Sale {
OrderId = 10438,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 840,
Date = DateTime.Parse("2013/10/18")
},
new Sale {
OrderId = 10439,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 7300,
Date = DateTime.Parse("2013/10/24")
},
new Sale {
OrderId = 10440,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 5950,
Date = DateTime.Parse("2013/10/11")
},
new Sale {
OrderId = 10441,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 3220,
Date = DateTime.Parse("2013/10/25")
},
new Sale {
OrderId = 10442,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 4470,
Date = DateTime.Parse("2013/10/05")
},
new Sale {
OrderId = 10443,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 3675,
Date = DateTime.Parse("2013/10/23")
},
new Sale {
OrderId = 10444,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 4260,
Date = DateTime.Parse("2013/10/01")
},
new Sale {
OrderId = 10445,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 4245,
Date = DateTime.Parse("2013/10/26")
},
new Sale {
OrderId = 10446,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 1470,
Date = DateTime.Parse("2013/10/01")
},
new Sale {
OrderId = 10447,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 1810,
Date = DateTime.Parse("2013/10/02")
},
new Sale {
OrderId = 10448,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 600,
Date = DateTime.Parse("2013/10/23")
},
new Sale {
OrderId = 10449,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 7500,
Date = DateTime.Parse("2013/11/03")
},
new Sale {
OrderId = 10450,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 4625,
Date = DateTime.Parse("2013/11/02")
},
new Sale {
OrderId = 10451,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 2625,
Date = DateTime.Parse("2013/11/09")
},
new Sale {
OrderId = 10452,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 1440,
Date = DateTime.Parse("2013/11/15")
},
new Sale {
OrderId = 10453,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 2420,
Date = DateTime.Parse("2013/11/15")
},
new Sale {
OrderId = 10454,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 4180,
Date = DateTime.Parse("2013/11/15")
},
new Sale {
OrderId = 10455,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 3720,
Date = DateTime.Parse("2013/11/25")
},
new Sale {
OrderId = 10456,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 2730,
Date = DateTime.Parse("2013/11/08")
},
new Sale {
OrderId = 10457,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 3775,
Date = DateTime.Parse("2013/11/17")
},
new Sale {
OrderId = 10458,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 3525,
Date = DateTime.Parse("2013/11/15")
},
new Sale {
OrderId = 10459,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 5320,
Date = DateTime.Parse("2013/11/08")
},
new Sale {
OrderId = 10460,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 7050,
Date = DateTime.Parse("2013/11/14")
},
new Sale {
OrderId = 10461,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 4200,
Date = DateTime.Parse("2013/11/18")
},
new Sale {
OrderId = 10462,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 4960,
Date = DateTime.Parse("2013/11/04")
},
new Sale {
OrderId = 10463,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 2280,
Date = DateTime.Parse("2013/11/13")
},
new Sale {
OrderId = 10464,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 590,
Date = DateTime.Parse("2013/11/11")
},
new Sale {
OrderId = 10465,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 810,
Date = DateTime.Parse("2013/11/12")
},
new Sale {
OrderId = 10466,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 2625,
Date = DateTime.Parse("2013/11/07")
},
new Sale {
OrderId = 10467,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 8280,
Date = DateTime.Parse("2013/12/01")
},
new Sale {
OrderId = 10468,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 5650,
Date = DateTime.Parse("2013/12/19")
},
new Sale {
OrderId = 10469,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 2760,
Date = DateTime.Parse("2013/12/14")
},
new Sale {
OrderId = 10470,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 2670,
Date = DateTime.Parse("2013/12/03")
},
new Sale {
OrderId = 10471,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 2520,
Date = DateTime.Parse("2013/12/20")
},
new Sale {
OrderId = 10472,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 4080,
Date = DateTime.Parse("2013/12/21")
},
new Sale {
OrderId = 10473,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 4140,
Date = DateTime.Parse("2013/12/22")
},
new Sale {
OrderId = 10474,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 390,
Date = DateTime.Parse("2013/12/04")
},
new Sale {
OrderId = 10475,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 1400,
Date = DateTime.Parse("2013/12/19")
},
new Sale {
OrderId = 10476,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 7275,
Date = DateTime.Parse("2013/12/22")
},
new Sale {
OrderId = 10477,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 4100,
Date = DateTime.Parse("2013/12/20")
},
new Sale {
OrderId = 10478,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 7290,
Date = DateTime.Parse("2013/12/05")
},
new Sale {
OrderId = 10479,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 625,
Date = DateTime.Parse("2013/12/22")
},
new Sale {
OrderId = 10480,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 4460,
Date = DateTime.Parse("2013/12/12")
},
new Sale {
OrderId = 10481,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 3825,
Date = DateTime.Parse("2013/12/13")
},
new Sale {
OrderId = 10482,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 2850,
Date = DateTime.Parse("2013/12/17")
},
new Sale {
OrderId = 10483,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 2780,
Date = DateTime.Parse("2013/12/07")
},
new Sale {
OrderId = 10484,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 840,
Date = DateTime.Parse("2013/12/18")
},
new Sale {
OrderId = 10485,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 2970,
Date = DateTime.Parse("2013/12/23")
},
new Sale {
OrderId = 10486,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 945,
Date = DateTime.Parse("2013/12/06")
},
new Sale {
OrderId = 10487,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 2625,
Date = DateTime.Parse("2013/12/04")
},
new Sale {
OrderId = 10488,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 390,
Date = DateTime.Parse("2013/12/01")
},
new Sale {
OrderId = 10489,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 7710,
Date = DateTime.Parse("2014/01/18")
},
new Sale {
OrderId = 10490,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 7975,
Date = DateTime.Parse("2014/01/10")
},
new Sale {
OrderId = 10491,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 3285,
Date = DateTime.Parse("2014/01/13")
},
new Sale {
OrderId = 10492,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 2580,
Date = DateTime.Parse("2014/01/22")
},
new Sale {
OrderId = 10493,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 2160,
Date = DateTime.Parse("2014/01/26")
},
new Sale {
OrderId = 10494,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 1100,
Date = DateTime.Parse("2014/01/25")
},
new Sale {
OrderId = 10495,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 4425,
Date = DateTime.Parse("2014/01/21")
},
new Sale {
OrderId = 10496,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 1360,
Date = DateTime.Parse("2014/01/22")
},
new Sale {
OrderId = 10497,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 3250,
Date = DateTime.Parse("2014/01/14")
},
new Sale {
OrderId = 10498,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 5550,
Date = DateTime.Parse("2014/01/21")
},
new Sale {
OrderId = 10499,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 2860,
Date = DateTime.Parse("2014/01/25")
},
new Sale {
OrderId = 10500,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 3450,
Date = DateTime.Parse("2014/01/24")
},
new Sale {
OrderId = 10501,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 5425,
Date = DateTime.Parse("2014/01/11")
},
new Sale {
OrderId = 10502,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 4860,
Date = DateTime.Parse("2014/01/12")
},
new Sale {
OrderId = 10503,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 4695,
Date = DateTime.Parse("2014/01/16")
},
new Sale {
OrderId = 10504,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 610,
Date = DateTime.Parse("2014/01/05")
},
new Sale {
OrderId = 10505,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 1580,
Date = DateTime.Parse("2014/01/15")
},
new Sale {
OrderId = 10506,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 3780,
Date = DateTime.Parse("2014/02/18")
},
new Sale {
OrderId = 10507,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 5400,
Date = DateTime.Parse("2014/02/21")
},
new Sale {
OrderId = 10508,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 630,
Date = DateTime.Parse("2014/02/18")
},
new Sale {
OrderId = 10509,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 3960,
Date = DateTime.Parse("2014/02/04")
},
new Sale {
OrderId = 10510,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 2010,
Date = DateTime.Parse("2014/02/25")
},
new Sale {
OrderId = 10511,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 5000,
Date = DateTime.Parse("2014/02/01")
},
new Sale {
OrderId = 10512,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 1995,
Date = DateTime.Parse("2014/02/20")
},
new Sale {
OrderId = 10513,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 860,
Date = DateTime.Parse("2014/02/12")
},
new Sale {
OrderId = 10514,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 2150,
Date = DateTime.Parse("2014/02/10")
},
new Sale {
OrderId = 10515,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 4050,
Date = DateTime.Parse("2014/02/06")
},
new Sale {
OrderId = 10516,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 2960,
Date = DateTime.Parse("2014/02/18")
},
new Sale {
OrderId = 10517,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 3390,
Date = DateTime.Parse("2014/02/03")
},
new Sale {
OrderId = 10518,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 4425,
Date = DateTime.Parse("2014/02/15")
},
new Sale {
OrderId = 10519,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 1180,
Date = DateTime.Parse("2014/02/23")
},
new Sale {
OrderId = 10520,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 360,
Date = DateTime.Parse("2014/02/08")
},
new Sale {
OrderId = 10521,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 2310,
Date = DateTime.Parse("2014/02/13")
},
new Sale {
OrderId = 10522,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 1770,
Date = DateTime.Parse("2014/02/20")
},
new Sale {
OrderId = 10523,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 3060,
Date = DateTime.Parse("2014/02/26")
},
new Sale {
OrderId = 10524,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 1750,
Date = DateTime.Parse("2014/02/12")
},
new Sale {
OrderId = 10525,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 2280,
Date = DateTime.Parse("2014/03/09")
},
new Sale {
OrderId = 10526,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 7600,
Date = DateTime.Parse("2014/03/25")
},
new Sale {
OrderId = 10527,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 1035,
Date = DateTime.Parse("2014/03/23")
},
new Sale {
OrderId = 10528,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 1245,
Date = DateTime.Parse("2014/03/01")
},
new Sale {
OrderId = 10529,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 2860,
Date = DateTime.Parse("2014/03/19")
},
new Sale {
OrderId = 10530,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 440,
Date = DateTime.Parse("2014/03/19")
},
new Sale {
OrderId = 10531,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 4665,
Date = DateTime.Parse("2014/03/02")
},
new Sale {
OrderId = 10532,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 2270,
Date = DateTime.Parse("2014/03/15")
},
new Sale {
OrderId = 10533,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 5000,
Date = DateTime.Parse("2014/03/09")
},
new Sale {
OrderId = 10534,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 5100,
Date = DateTime.Parse("2014/03/23")
},
new Sale {
OrderId = 10535,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 2120,
Date = DateTime.Parse("2014/03/11")
},
new Sale {
OrderId = 10536,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 9510,
Date = DateTime.Parse("2014/03/19")
},
new Sale {
OrderId = 10537,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 7600,
Date = DateTime.Parse("2014/03/21")
},
new Sale {
OrderId = 10538,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 5420,
Date = DateTime.Parse("2014/03/15")
},
new Sale {
OrderId = 10539,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 1980,
Date = DateTime.Parse("2014/03/05")
},
new Sale {
OrderId = 10540,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 1820,
Date = DateTime.Parse("2014/03/07")
},
new Sale {
OrderId = 10541,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 1670,
Date = DateTime.Parse("2014/03/21")
},
new Sale {
OrderId = 10542,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 4800,
Date = DateTime.Parse("2014/03/08")
},
new Sale {
OrderId = 10543,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 2925,
Date = DateTime.Parse("2014/03/03")
},
new Sale {
OrderId = 10544,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 2940,
Date = DateTime.Parse("2014/04/11")
},
new Sale {
OrderId = 10545,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 3525,
Date = DateTime.Parse("2014/04/13")
},
new Sale {
OrderId = 10546,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 2475,
Date = DateTime.Parse("2014/04/22")
},
new Sale {
OrderId = 10547,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 3315,
Date = DateTime.Parse("2014/04/08")
},
new Sale {
OrderId = 10548,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 3140,
Date = DateTime.Parse("2014/04/07")
},
new Sale {
OrderId = 10549,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 2520,
Date = DateTime.Parse("2014/04/01")
},
new Sale {
OrderId = 10550,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 1200,
Date = DateTime.Parse("2014/04/10")
},
new Sale {
OrderId = 10551,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 2060,
Date = DateTime.Parse("2014/04/21")
},
new Sale {
OrderId = 10552,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 7875,
Date = DateTime.Parse("2014/04/02")
},
new Sale {
OrderId = 10553,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 1450,
Date = DateTime.Parse("2014/04/07")
},
new Sale {
OrderId = 10554,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 2640,
Date = DateTime.Parse("2014/04/22")
},
new Sale {
OrderId = 10555,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 4500,
Date = DateTime.Parse("2014/04/05")
},
new Sale {
OrderId = 10556,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 5050,
Date = DateTime.Parse("2014/04/11")
},
new Sale {
OrderId = 10557,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 2940,
Date = DateTime.Parse("2014/04/02")
},
new Sale {
OrderId = 10558,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 2880,
Date = DateTime.Parse("2014/04/14")
},
new Sale {
OrderId = 10559,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 1050,
Date = DateTime.Parse("2014/04/19")
},
new Sale {
OrderId = 10560,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 1850,
Date = DateTime.Parse("2014/04/02")
},
new Sale {
OrderId = 10561,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 3160,
Date = DateTime.Parse("2014/04/01")
},
new Sale {
OrderId = 10562,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 875,
Date = DateTime.Parse("2014/04/04")
},
new Sale {
OrderId = 10563,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 1380,
Date = DateTime.Parse("2014/04/21")
},
new Sale {
OrderId = 10564,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 3060,
Date = DateTime.Parse("2014/04/06")
},
new Sale {
OrderId = 10565,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 6690,
Date = DateTime.Parse("2014/05/19")
},
new Sale {
OrderId = 10566,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 4525,
Date = DateTime.Parse("2014/05/15")
},
new Sale {
OrderId = 10567,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 4665,
Date = DateTime.Parse("2014/05/10")
},
new Sale {
OrderId = 10568,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 4530,
Date = DateTime.Parse("2014/05/18")
},
new Sale {
OrderId = 10569,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 1330,
Date = DateTime.Parse("2014/05/08")
},
new Sale {
OrderId = 10570,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 1720,
Date = DateTime.Parse("2014/05/20")
},
new Sale {
OrderId = 10571,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 3750,
Date = DateTime.Parse("2014/05/16")
},
new Sale {
OrderId = 10572,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 1290,
Date = DateTime.Parse("2014/05/10")
},
new Sale {
OrderId = 10573,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 4925,
Date = DateTime.Parse("2014/05/14")
},
new Sale {
OrderId = 10574,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 4300,
Date = DateTime.Parse("2014/05/22")
},
new Sale {
OrderId = 10575,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 5740,
Date = DateTime.Parse("2014/05/08")
},
new Sale {
OrderId = 10576,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 1440,
Date = DateTime.Parse("2014/05/21")
},
new Sale {
OrderId = 10577,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 5975,
Date = DateTime.Parse("2014/05/25")
},
new Sale {
OrderId = 10578,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 4440,
Date = DateTime.Parse("2014/05/05")
},
new Sale {
OrderId = 10579,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 2310,
Date = DateTime.Parse("2014/05/24")
},
new Sale {
OrderId = 10580,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 2250,
Date = DateTime.Parse("2014/05/06")
},
new Sale {
OrderId = 10581,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 2320,
Date = DateTime.Parse("2014/05/14")
},
new Sale {
OrderId = 10582,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 5190,
Date = DateTime.Parse("2014/06/26")
},
new Sale {
OrderId = 10583,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 925,
Date = DateTime.Parse("2014/06/04")
},
new Sale {
OrderId = 10584,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 3240,
Date = DateTime.Parse("2014/06/20")
},
new Sale {
OrderId = 10585,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 3180,
Date = DateTime.Parse("2014/06/23")
},
new Sale {
OrderId = 10586,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 780,
Date = DateTime.Parse("2014/06/13")
},
new Sale {
OrderId = 10587,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 4680,
Date = DateTime.Parse("2014/06/08")
},
new Sale {
OrderId = 10588,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 2475,
Date = DateTime.Parse("2014/06/25")
},
new Sale {
OrderId = 10589,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 1920,
Date = DateTime.Parse("2014/06/20")
},
new Sale {
OrderId = 10590,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 7500,
Date = DateTime.Parse("2014/06/25")
},
new Sale {
OrderId = 10591,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 5025,
Date = DateTime.Parse("2014/06/26")
},
new Sale {
OrderId = 10592,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 2400,
Date = DateTime.Parse("2014/06/08")
},
new Sale {
OrderId = 10593,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 5430,
Date = DateTime.Parse("2014/06/03")
},
new Sale {
OrderId = 10594,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 4475,
Date = DateTime.Parse("2014/06/19")
},
new Sale {
OrderId = 10595,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 1420,
Date = DateTime.Parse("2014/06/20")
},
new Sale {
OrderId = 10596,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 2670,
Date = DateTime.Parse("2014/06/25")
},
new Sale {
OrderId = 10597,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 1930,
Date = DateTime.Parse("2014/06/02")
},
new Sale {
OrderId = 10598,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 580,
Date = DateTime.Parse("2014/06/25")
},
new Sale {
OrderId = 10599,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 1620,
Date = DateTime.Parse("2014/06/12")
},
new Sale {
OrderId = 10600,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 4530,
Date = DateTime.Parse("2014/06/02")
},
new Sale {
OrderId = 10601,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 6025,
Date = DateTime.Parse("2014/06/23")
},
new Sale {
OrderId = 10602,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 3540,
Date = DateTime.Parse("2014/07/21")
},
new Sale {
OrderId = 10603,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 3000,
Date = DateTime.Parse("2014/07/01")
},
new Sale {
OrderId = 10604,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 3240,
Date = DateTime.Parse("2014/07/26")
},
new Sale {
OrderId = 10605,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 2265,
Date = DateTime.Parse("2014/07/22")
},
new Sale {
OrderId = 10606,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 400,
Date = DateTime.Parse("2014/07/09")
},
new Sale {
OrderId = 10607,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 1460,
Date = DateTime.Parse("2014/07/08")
},
new Sale {
OrderId = 10608,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 1620,
Date = DateTime.Parse("2014/07/18")
},
new Sale {
OrderId = 10609,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 2400,
Date = DateTime.Parse("2014/07/25")
},
new Sale {
OrderId = 10610,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 5275,
Date = DateTime.Parse("2014/07/04")
},
new Sale {
OrderId = 10611,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 4475,
Date = DateTime.Parse("2014/07/03")
},
new Sale {
OrderId = 10612,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 3980,
Date = DateTime.Parse("2014/07/21")
},
new Sale {
OrderId = 10613,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 5700,
Date = DateTime.Parse("2014/07/18")
},
new Sale {
OrderId = 10614,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 5575,
Date = DateTime.Parse("2014/07/01")
},
new Sale {
OrderId = 10615,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 2160,
Date = DateTime.Parse("2014/07/02")
},
new Sale {
OrderId = 10616,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 960,
Date = DateTime.Parse("2014/07/09")
},
new Sale {
OrderId = 10617,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 1280,
Date = DateTime.Parse("2014/07/04")
},
new Sale {
OrderId = 10618,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 1040,
Date = DateTime.Parse("2014/07/02")
},
new Sale {
OrderId = 10619,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 1760,
Date = DateTime.Parse("2014/07/25")
},
new Sale {
OrderId = 10620,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 4080,
Date = DateTime.Parse("2014/07/07")
},
new Sale {
OrderId = 10621,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 1000,
Date = DateTime.Parse("2014/07/21")
},
new Sale {
OrderId = 10622,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 1770,
Date = DateTime.Parse("2014/08/23")
},
new Sale {
OrderId = 10623,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 2700,
Date = DateTime.Parse("2014/08/09")
},
new Sale {
OrderId = 10624,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 2175,
Date = DateTime.Parse("2014/08/03")
},
new Sale {
OrderId = 10625,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 3375,
Date = DateTime.Parse("2014/08/11")
},
new Sale {
OrderId = 10626,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 2040,
Date = DateTime.Parse("2014/08/01")
},
new Sale {
OrderId = 10627,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 3000,
Date = DateTime.Parse("2014/08/21")
},
new Sale {
OrderId = 10628,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 3900,
Date = DateTime.Parse("2014/08/16")
},
new Sale {
OrderId = 10629,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 1370,
Date = DateTime.Parse("2014/08/20")
},
new Sale {
OrderId = 10630,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 5700,
Date = DateTime.Parse("2014/08/01")
},
new Sale {
OrderId = 10631,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 1275,
Date = DateTime.Parse("2014/08/22")
},
new Sale {
OrderId = 10632,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 4060,
Date = DateTime.Parse("2014/08/13")
},
new Sale {
OrderId = 10633,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 4560,
Date = DateTime.Parse("2014/08/20")
},
new Sale {
OrderId = 10634,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 7575,
Date = DateTime.Parse("2014/08/20")
},
new Sale {
OrderId = 10635,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 700,
Date = DateTime.Parse("2014/08/25")
},
new Sale {
OrderId = 10636,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 2400,
Date = DateTime.Parse("2014/08/16")
},
new Sale {
OrderId = 10637,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 1390,
Date = DateTime.Parse("2014/08/15")
},
new Sale {
OrderId = 10638,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 1320,
Date = DateTime.Parse("2014/08/09")
},
new Sale {
OrderId = 10639,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 1680,
Date = DateTime.Parse("2014/08/09")
},
new Sale {
OrderId = 10640,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 1500,
Date = DateTime.Parse("2014/08/11")
},
new Sale {
OrderId = 10641,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 6150,
Date = DateTime.Parse("2014/09/21")
},
new Sale {
OrderId = 10642,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 3675,
Date = DateTime.Parse("2014/09/02")
},
new Sale {
OrderId = 10643,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 2250,
Date = DateTime.Parse("2014/09/05")
},
new Sale {
OrderId = 10644,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 3585,
Date = DateTime.Parse("2014/09/10")
},
new Sale {
OrderId = 10645,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 1470,
Date = DateTime.Parse("2014/09/01")
},
new Sale {
OrderId = 10646,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 2260,
Date = DateTime.Parse("2014/09/02")
},
new Sale {
OrderId = 10647,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 3765,
Date = DateTime.Parse("2014/09/03")
},
new Sale {
OrderId = 10648,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 1640,
Date = DateTime.Parse("2014/09/04")
},
new Sale {
OrderId = 10649,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 4475,
Date = DateTime.Parse("2014/09/09")
},
new Sale {
OrderId = 10650,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 5975,
Date = DateTime.Parse("2014/09/04")
},
new Sale {
OrderId = 10651,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 1100,
Date = DateTime.Parse("2014/09/16")
},
new Sale {
OrderId = 10652,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 9210,
Date = DateTime.Parse("2014/09/09")
},
new Sale {
OrderId = 10653,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 3700,
Date = DateTime.Parse("2014/09/01")
},
new Sale {
OrderId = 10654,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 3620,
Date = DateTime.Parse("2014/09/19")
},
new Sale {
OrderId = 10655,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 4275,
Date = DateTime.Parse("2014/09/01")
},
new Sale {
OrderId = 10656,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 2370,
Date = DateTime.Parse("2014/09/03")
},
new Sale {
OrderId = 10657,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 1870,
Date = DateTime.Parse("2014/09/10")
},
new Sale {
OrderId = 10658,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 2070,
Date = DateTime.Parse("2014/09/25")
},
new Sale {
OrderId = 10659,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 5025,
Date = DateTime.Parse("2014/09/19")
},
new Sale {
OrderId = 10660,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 1080,
Date = DateTime.Parse("2014/10/15")
},
new Sale {
OrderId = 10661,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 1400,
Date = DateTime.Parse("2014/10/22")
},
new Sale {
OrderId = 10662,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 4260,
Date = DateTime.Parse("2014/10/01")
},
new Sale {
OrderId = 10663,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 2745,
Date = DateTime.Parse("2014/10/01")
},
new Sale {
OrderId = 10664,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 2920,
Date = DateTime.Parse("2014/10/23")
},
new Sale {
OrderId = 10665,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 3520,
Date = DateTime.Parse("2014/10/11")
},
new Sale {
OrderId = 10666,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 4035,
Date = DateTime.Parse("2014/10/20")
},
new Sale {
OrderId = 10667,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 1730,
Date = DateTime.Parse("2014/10/05")
},
new Sale {
OrderId = 10668,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 975,
Date = DateTime.Parse("2014/10/06")
},
new Sale {
OrderId = 10669,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 5700,
Date = DateTime.Parse("2014/10/06")
},
new Sale {
OrderId = 10670,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 5080,
Date = DateTime.Parse("2014/10/18")
},
new Sale {
OrderId = 10671,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 1230,
Date = DateTime.Parse("2014/10/11")
},
new Sale {
OrderId = 10672,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 600,
Date = DateTime.Parse("2014/10/08")
},
new Sale {
OrderId = 10673,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 3700,
Date = DateTime.Parse("2014/10/08")
},
new Sale {
OrderId = 10674,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 3375,
Date = DateTime.Parse("2014/10/11")
},
new Sale {
OrderId = 10675,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 1500,
Date = DateTime.Parse("2014/10/17")
},
new Sale {
OrderId = 10676,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 370,
Date = DateTime.Parse("2014/10/05")
},
new Sale {
OrderId = 10677,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 2340,
Date = DateTime.Parse("2014/10/16")
},
new Sale {
OrderId = 10678,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 1080,
Date = DateTime.Parse("2014/10/08")
},
new Sale {
OrderId = 10679,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 2775,
Date = DateTime.Parse("2014/10/21")
},
new Sale {
OrderId = 10680,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 4380,
Date = DateTime.Parse("2014/11/09")
},
new Sale {
OrderId = 10681,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 5500,
Date = DateTime.Parse("2014/11/21")
},
new Sale {
OrderId = 10682,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 1920,
Date = DateTime.Parse("2014/11/24")
},
new Sale {
OrderId = 10683,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 765,
Date = DateTime.Parse("2014/11/24")
},
new Sale {
OrderId = 10684,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 370,
Date = DateTime.Parse("2014/11/18")
},
new Sale {
OrderId = 10685,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 3500,
Date = DateTime.Parse("2014/11/25")
},
new Sale {
OrderId = 10686,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 825,
Date = DateTime.Parse("2014/11/09")
},
new Sale {
OrderId = 10687,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 490,
Date = DateTime.Parse("2014/11/23")
},
new Sale {
OrderId = 10688,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 7075,
Date = DateTime.Parse("2014/11/20")
},
new Sale {
OrderId = 10689,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 1350,
Date = DateTime.Parse("2014/11/25")
},
new Sale {
OrderId = 10690,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 1440,
Date = DateTime.Parse("2014/11/15")
},
new Sale {
OrderId = 10691,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 1110,
Date = DateTime.Parse("2014/11/03")
},
new Sale {
OrderId = 10692,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 1150,
Date = DateTime.Parse("2014/11/23")
},
new Sale {
OrderId = 10693,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 2040,
Date = DateTime.Parse("2014/11/20")
},
new Sale {
OrderId = 10694,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 3090,
Date = DateTime.Parse("2014/11/24")
},
new Sale {
OrderId = 10695,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 1940,
Date = DateTime.Parse("2014/11/24")
},
new Sale {
OrderId = 10696,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 3090,
Date = DateTime.Parse("2014/11/16")
},
new Sale {
OrderId = 10697,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 4900,
Date = DateTime.Parse("2014/11/05")
},
new Sale {
OrderId = 10698,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 3465,
Date = DateTime.Parse("2014/11/07")
},
new Sale {
OrderId = 10699,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 1110,
Date = DateTime.Parse("2014/11/20")
},
new Sale {
OrderId = 10700,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 1650,
Date = DateTime.Parse("2014/11/02")
},
new Sale {
OrderId = 10701,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 5280,
Date = DateTime.Parse("2014/12/04")
},
new Sale {
OrderId = 10702,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 3075,
Date = DateTime.Parse("2014/12/02")
},
new Sale {
OrderId = 10703,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 690,
Date = DateTime.Parse("2014/12/07")
},
new Sale {
OrderId = 10704,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 1305,
Date = DateTime.Parse("2014/12/15")
},
new Sale {
OrderId = 10705,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 1970,
Date = DateTime.Parse("2014/12/01")
},
new Sale {
OrderId = 10706,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 3760,
Date = DateTime.Parse("2014/12/18")
},
new Sale {
OrderId = 10707,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 1920,
Date = DateTime.Parse("2014/12/22")
},
new Sale {
OrderId = 10708,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 1360,
Date = DateTime.Parse("2014/12/12")
},
new Sale {
OrderId = 10709,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 2525,
Date = DateTime.Parse("2014/12/06")
},
new Sale {
OrderId = 10710,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 5575,
Date = DateTime.Parse("2014/12/20")
},
new Sale {
OrderId = 10711,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 5560,
Date = DateTime.Parse("2014/12/10")
},
new Sale {
OrderId = 10712,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 2820,
Date = DateTime.Parse("2014/12/10")
},
new Sale {
OrderId = 10713,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 4000,
Date = DateTime.Parse("2014/12/12")
},
new Sale {
OrderId = 10714,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 5820,
Date = DateTime.Parse("2014/12/02")
},
new Sale {
OrderId = 10715,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 1275,
Date = DateTime.Parse("2014/12/12")
},
new Sale {
OrderId = 10716,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 1310,
Date = DateTime.Parse("2014/12/01")
},
new Sale {
OrderId = 10717,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 2180,
Date = DateTime.Parse("2014/12/26")
},
new Sale {
OrderId = 10718,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 4470,
Date = DateTime.Parse("2014/12/17")
},
new Sale {
OrderId = 10719,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 2990,
Date = DateTime.Parse("2014/12/15")
},
new Sale {
OrderId = 10720,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 7650,
Date = DateTime.Parse("2014/12/18")
},
new Sale {
OrderId = 10721,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 780,
Date = DateTime.Parse("2014/12/02")
},
new Sale {
OrderId = 10722,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 2970,
Date = DateTime.Parse("2014/12/13")
},
new Sale {
OrderId = 10723,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 1155,
Date = DateTime.Parse("2014/12/05")
},
new Sale {
OrderId = 10724,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 4470,
Date = DateTime.Parse("2015/01/10")
},
new Sale {
OrderId = 10725,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 1125,
Date = DateTime.Parse("2015/01/21")
},
new Sale {
OrderId = 10726,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 645,
Date = DateTime.Parse("2015/01/17")
},
new Sale {
OrderId = 10727,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 675,
Date = DateTime.Parse("2015/01/05")
},
new Sale {
OrderId = 10728,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 2840,
Date = DateTime.Parse("2015/01/05")
},
new Sale {
OrderId = 10729,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 2660,
Date = DateTime.Parse("2015/01/04")
},
new Sale {
OrderId = 10730,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 4560,
Date = DateTime.Parse("2015/01/12")
},
new Sale {
OrderId = 10731,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 2880,
Date = DateTime.Parse("2015/01/20")
},
new Sale {
OrderId = 10732,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 500,
Date = DateTime.Parse("2015/01/02")
},
new Sale {
OrderId = 10733,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 3925,
Date = DateTime.Parse("2015/01/07")
},
new Sale {
OrderId = 10734,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 5660,
Date = DateTime.Parse("2015/01/18")
},
new Sale {
OrderId = 10735,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 4830,
Date = DateTime.Parse("2015/01/13")
},
new Sale {
OrderId = 10736,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 3075,
Date = DateTime.Parse("2015/01/22")
},
new Sale {
OrderId = 10737,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 3120,
Date = DateTime.Parse("2015/01/14")
},
new Sale {
OrderId = 10738,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 3525,
Date = DateTime.Parse("2015/01/23")
},
new Sale {
OrderId = 10739,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 1930,
Date = DateTime.Parse("2015/01/09")
},
new Sale {
OrderId = 10740,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 2890,
Date = DateTime.Parse("2015/01/02")
},
new Sale {
OrderId = 10741,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 1545,
Date = DateTime.Parse("2015/01/17")
},
new Sale {
OrderId = 10742,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 3630,
Date = DateTime.Parse("2015/01/20")
},
new Sale {
OrderId = 10743,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 4035,
Date = DateTime.Parse("2015/01/14")
},
new Sale {
OrderId = 10744,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 345,
Date = DateTime.Parse("2015/01/06")
},
new Sale {
OrderId = 10745,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 7000,
Date = DateTime.Parse("2015/01/07")
},
new Sale {
OrderId = 10746,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 3060,
Date = DateTime.Parse("2015/02/13")
},
new Sale {
OrderId = 10747,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 6425,
Date = DateTime.Parse("2015/02/04")
},
new Sale {
OrderId = 10748,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 615,
Date = DateTime.Parse("2015/02/22")
},
new Sale {
OrderId = 10749,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 1755,
Date = DateTime.Parse("2015/02/07")
},
new Sale {
OrderId = 10750,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 1540,
Date = DateTime.Parse("2015/02/21")
},
new Sale {
OrderId = 10751,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 2820,
Date = DateTime.Parse("2015/02/24")
},
new Sale {
OrderId = 10752,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 4305,
Date = DateTime.Parse("2015/02/10")
},
new Sale {
OrderId = 10753,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 1520,
Date = DateTime.Parse("2015/02/26")
},
new Sale {
OrderId = 10754,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 4725,
Date = DateTime.Parse("2015/02/18")
},
new Sale {
OrderId = 10755,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 6750,
Date = DateTime.Parse("2015/02/16")
},
new Sale {
OrderId = 10756,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 5540,
Date = DateTime.Parse("2015/02/07")
},
new Sale {
OrderId = 10757,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 9300,
Date = DateTime.Parse("2015/02/03")
},
new Sale {
OrderId = 10758,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 3700,
Date = DateTime.Parse("2015/02/26")
},
new Sale {
OrderId = 10759,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 740,
Date = DateTime.Parse("2015/02/01")
},
new Sale {
OrderId = 10760,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 4755,
Date = DateTime.Parse("2015/02/23")
},
new Sale {
OrderId = 10761,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 2570,
Date = DateTime.Parse("2015/02/20")
},
new Sale {
OrderId = 10762,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 2860,
Date = DateTime.Parse("2015/02/19")
},
new Sale {
OrderId = 10763,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 5430,
Date = DateTime.Parse("2015/03/21")
},
new Sale {
OrderId = 10764,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 4525,
Date = DateTime.Parse("2015/03/21")
},
new Sale {
OrderId = 10765,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 1515,
Date = DateTime.Parse("2015/03/10")
},
new Sale {
OrderId = 10766,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 630,
Date = DateTime.Parse("2015/03/15")
},
new Sale {
OrderId = 10767,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 1310,
Date = DateTime.Parse("2015/03/01")
},
new Sale {
OrderId = 10768,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 3200,
Date = DateTime.Parse("2015/03/17")
},
new Sale {
OrderId = 10769,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 3945,
Date = DateTime.Parse("2015/03/20")
},
new Sale {
OrderId = 10770,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 2990,
Date = DateTime.Parse("2015/03/18")
},
new Sale {
OrderId = 10771,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 1125,
Date = DateTime.Parse("2015/03/22")
},
new Sale {
OrderId = 10772,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 7950,
Date = DateTime.Parse("2015/03/17")
},
new Sale {
OrderId = 10773,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 2960,
Date = DateTime.Parse("2015/03/25")
},
new Sale {
OrderId = 10774,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 3930,
Date = DateTime.Parse("2015/03/23")
},
new Sale {
OrderId = 10775,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 6975,
Date = DateTime.Parse("2015/03/02")
},
new Sale {
OrderId = 10776,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 4220,
Date = DateTime.Parse("2015/03/17")
},
new Sale {
OrderId = 10777,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 3090,
Date = DateTime.Parse("2015/03/25")
},
new Sale {
OrderId = 10778,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 2380,
Date = DateTime.Parse("2015/03/01")
},
new Sale {
OrderId = 10779,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 1510,
Date = DateTime.Parse("2015/03/07")
},
new Sale {
OrderId = 10780,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 1020,
Date = DateTime.Parse("2015/03/19")
},
new Sale {
OrderId = 10781,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 6700,
Date = DateTime.Parse("2015/03/26")
},
new Sale {
OrderId = 10782,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 4890,
Date = DateTime.Parse("2015/04/02")
},
new Sale {
OrderId = 10783,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 7225,
Date = DateTime.Parse("2015/04/13")
},
new Sale {
OrderId = 10784,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 795,
Date = DateTime.Parse("2015/04/07")
},
new Sale {
OrderId = 10785,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 1785,
Date = DateTime.Parse("2015/04/03")
},
new Sale {
OrderId = 10786,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 1850,
Date = DateTime.Parse("2015/04/03")
},
new Sale {
OrderId = 10787,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 5120,
Date = DateTime.Parse("2015/04/12")
},
new Sale {
OrderId = 10788,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 615,
Date = DateTime.Parse("2015/04/07")
},
new Sale {
OrderId = 10789,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 2860,
Date = DateTime.Parse("2015/04/05")
},
new Sale {
OrderId = 10790,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 1525,
Date = DateTime.Parse("2015/04/24")
},
new Sale {
OrderId = 10791,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 7425,
Date = DateTime.Parse("2015/04/15")
},
new Sale {
OrderId = 10792,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 6080,
Date = DateTime.Parse("2015/04/13")
},
new Sale {
OrderId = 10793,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 9390,
Date = DateTime.Parse("2015/04/19")
},
new Sale {
OrderId = 10794,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 3200,
Date = DateTime.Parse("2015/04/26")
},
new Sale {
OrderId = 10795,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 4380,
Date = DateTime.Parse("2015/04/05")
},
new Sale {
OrderId = 10796,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 4725,
Date = DateTime.Parse("2015/04/06")
},
new Sale {
OrderId = 10797,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 930,
Date = DateTime.Parse("2015/04/25")
},
new Sale {
OrderId = 10798,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 1910,
Date = DateTime.Parse("2015/04/05")
},
new Sale {
OrderId = 10799,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 2725,
Date = DateTime.Parse("2015/04/16")
},
new Sale {
OrderId = 10800,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 4720,
Date = DateTime.Parse("2015/04/02")
},
new Sale {
OrderId = 10801,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 2800,
Date = DateTime.Parse("2015/04/26")
},
new Sale {
OrderId = 10802,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 3780,
Date = DateTime.Parse("2015/04/24")
},
new Sale {
OrderId = 10803,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 2340,
Date = DateTime.Parse("2015/04/17")
},
new Sale {
OrderId = 10804,
Region = "North America",
Country = "United States",
City = "New York",
Amount = 4830,
Date = DateTime.Parse("2015/05/12")
},
new Sale {
OrderId = 10805,
Region = "North America",
Country = "United States",
City = "Los Angeles",
Amount = 2075,
Date = DateTime.Parse("2015/05/23")
},
new Sale {
OrderId = 10806,
Region = "North America",
Country = "United States",
City = "Denver",
Amount = 3420,
Date = DateTime.Parse("2015/05/21")
},
new Sale {
OrderId = 10807,
Region = "North America",
Country = "Canada",
City = "Vancouver",
Amount = 1440,
Date = DateTime.Parse("2015/05/10")
},
new Sale {
OrderId = 10808,
Region = "North America",
Country = "Canada",
City = "Edmonton",
Amount = 1680,
Date = DateTime.Parse("2015/05/15")
},
new Sale {
OrderId = 10809,
Region = "South America",
Country = "Brazil",
City = "Rio de Janeiro",
Amount = 3440,
Date = DateTime.Parse("2015/05/16")
},
new Sale {
OrderId = 10810,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 4695,
Date = DateTime.Parse("2015/05/10")
},
new Sale {
OrderId = 10811,
Region = "South America",
Country = "Paraguay",
City = "Asuncion",
Amount = 2380,
Date = DateTime.Parse("2015/05/06")
},
new Sale {
OrderId = 10812,
Region = "Europe",
Country = "United Kingdom",
City = "London",
Amount = 1875,
Date = DateTime.Parse("2015/05/25")
},
new Sale {
OrderId = 10813,
Region = "Europe",
Country = "Germany",
City = "Berlin",
Amount = 7550,
Date = DateTime.Parse("2015/05/14")
},
new Sale {
OrderId = 10814,
Region = "Europe",
Country = "Spain",
City = "Madrid",
Amount = 3340,
Date = DateTime.Parse("2015/05/01")
},
new Sale {
OrderId = 10815,
Region = "Asia",
Country = "Japan",
City = "Tokyo",
Amount = 8370,
Date = DateTime.Parse("2015/05/13")
},
new Sale {
OrderId = 10816,
Region = "Asia",
Country = "Republic of Korea",
City = "Seoul",
Amount = 3550,
Date = DateTime.Parse("2015/05/26")
},
new Sale {
OrderId = 10817,
Region = "Australia",
Country = "Australia",
City = "Sydney",
Amount = 2620,
Date = DateTime.Parse("2015/05/17")
},
new Sale {
OrderId = 10818,
Region = "Australia",
Country = "Australia",
City = "Melbourne",
Amount = 2400,
Date = DateTime.Parse("2015/05/21")
},
new Sale {
OrderId = 10819,
Region = "Africa",
Country = "South Africa",
City = "Pretoria",
Amount = 1740,
Date = DateTime.Parse("2015/05/21")
},
new Sale {
OrderId = 10820,
Region = "Africa",
Country = "Egypt",
City = "Cairo",
Amount = 500,
Date = DateTime.Parse("2015/05/26")
},
new Sale {
OrderId = 10821,
Region = "South America",
Country = "Argentina",
City = "Buenos Aires",
Amount = 780,
Date = DateTime.Parse("2015/05/07")
}
};
}
}
.options {
padding: 20px;
margin-top: 20px;
background-color: rgba(191, 191, 191, 0.15);
}
.caption {
font-size: 18px;
font-weight: 500;
}
.option {
width: 33%;
display: inline-block;
margin-top: 10px;
}
This demo illustrates the following properties:
-
rowHeaderLayout
Allows you to specify the layout type for row header items. The "standard" layout displays child items to the right of the parent items. Assign "tree" to this property to display items more densely as a hierarchical structure. -
showTotalsPrior
Specifies whether totals precede or follow data rows and columns. This property does not affect row totals when rowHeaderLayout is "tree". -
dataFieldArea
Specifies the area to which data headers belong: "column" or "row". Data headers appear only when the pivot grid has more than one data field (SalesandPercentin this demo).
Toggle the check boxes below the PivotGrid to change values of the showTotalsPrior, dataFieldArea, and rowHeaderLayout properties.