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