The tooltip can be enabled or disabled by setting the showTooltip
property to true. By default, tooltip is enabled in the pivot table.
@Html.EJS().PivotView("PivotView").Height("300").DataSourceSettings(dataSource => dataSource.DataSource((IEnumerable<object>)ViewBag.DataSource).ExpandAll(false).EnableSorting(true)
.FormatSettings(formatsettings =>
{
formatsettings.Name("Amount").Format("C0").MaximumSignificantDigits(10).MinimumSignificantDigits(1).UseGrouping(true).Add();
}).Rows(rows =>
{
rows.Name("Country").Add(); rows.Name("Products").Add();
}).Columns(columns =>
{
columns.Name("Year").Caption("Year").Add(); columns.Name("Quarter").Add();
}).Values(values =>
{
values.Name("Sold").Caption("Units Sold").Add(); values.Name("Amount").Caption("Sold Amount").Add();
})).ShowTooltip(false).Render()
public ActionResult Index()
{
var data = GetPivotData();
ViewBag.DataSource = data;
return View();
}
public List<PivotData> GetPivotData()
{
List<PivotData> pivotData = new List<PivotData>();
pivotData.Add(new PivotData { Sold = 31, Amount = 52824, Country = "France", Products = "Mountain Bikes", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 51, Amount = 86904, Country = "France", Products = "Mountain Bikes", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 90, Amount = 153360, Country = "France", Products = "Mountain Bikes", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 25, Amount = 42600, Country = "France", Products = "Mountain Bikes", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 27, Amount = 46008, Country = "France", Products = "Mountain Bikes", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 49, Amount = 83496, Country = "France", Products = "Mountain Bikes", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 95, Amount = 161880, Country = "France", Products = "Mountain Bikes", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 67, Amount = 114168, Country = "France", Products = "Mountain Bikes", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 75, Amount = 127800, Country = "France", Products = "Mountain Bikes", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 67, Amount = 114168, Country = "France", Products = "Mountain Bikes", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 69, Amount = 117576, Country = "France", Products = "Mountain Bikes", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 90, Amount = 153360, Country = "France", Products = "Mountain Bikes", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 16, Amount = 27264, Country = "France", Products = "Mountain Bikes", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 83, Amount = 124422, Country = "France", Products = "Road Bikes", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 57, Amount = 85448, Country = "France", Products = "Road Bikes", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 20, Amount = 29985, Country = "France", Products = "Road Bikes", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 93, Amount = 139412, Country = "France", Products = "Road Bikes", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 35, Amount = 52470, Country = "France", Products = "Road Bikes", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 28, Amount = 41977, Country = "France", Products = "Road Bikes", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 48, Amount = 71957, Country = "France", Products = "Road Bikes", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 36, Amount = 53969, Country = "France", Products = "Road Bikes", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 25, Amount = 37480, Country = "France", Products = "Road Bikes", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 69, Amount = 103436, Country = "France", Products = "Road Bikes", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 16, Amount = 23989, Country = "France", Products = "Road Bikes", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 28, Amount = 41977, Country = "France", Products = "Road Bikes", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 19, Amount = 28486, Country = "France", Products = "Road Bikes", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 89, Amount = 141999.5, Country = "France", Products = "Touring Bikes", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 91, Amount = 145190.5, Country = "France", Products = "Touring Bikes", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 24, Amount = 38292, Country = "France", Products = "Touring Bikes", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 75, Amount = 119662.5, Country = "France", Products = "Touring Bikes", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 100, Amount = 159550, Country = "France", Products = "Touring Bikes", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 30, Amount = 47865, Country = "France", Products = "Touring Bikes", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 69, Amount = 110089.5, Country = "France", Products = "Touring Bikes", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 25, Amount = 39887.5, Country = "France", Products = "Touring Bikes", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 42, Amount = 67011, Country = "France", Products = "Touring Bikes", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 94, Amount = 149977, Country = "France", Products = "Touring Bikes", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 76, Amount = 121258, Country = "France", Products = "Touring Bikes", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 52, Amount = 82966, Country = "France", Products = "Touring Bikes", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 33, Amount = 52651.5, Country = "France", Products = "Touring Bikes", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 16, Amount = 23989, Country = "Germany", Products = "Road Bikes", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 21, Amount = 33505.5, Country = "Germany", Products = "Touring Bikes", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 74, Amount = 126096, Country = "Germany", Products = "Mountain Bikes", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 99, Amount = 148406, Country = "Germany", Products = "Road Bikes", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 31, Amount = 49460.5, Country = "Germany", Products = "Touring Bikes", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 57, Amount = 97128, Country = "Germany", Products = "Mountain Bikes", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 41, Amount = 61464, Country = "Germany", Products = "Road Bikes", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 64, Amount = 102112, Country = "Germany", Products = "Touring Bikes", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 85, Amount = 144840, Country = "Germany", Products = "Mountain Bikes", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 76, Amount = 129504, Country = "Germany", Products = "Mountain Bikes", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 33, Amount = 56232, Country = "Germany", Products = "Mountain Bikes", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 71, Amount = 120984, Country = "Germany", Products = "Mountain Bikes", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 81, Amount = 138024, Country = "Germany", Products = "Mountain Bikes", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 65, Amount = 110760, Country = "Germany", Products = "Mountain Bikes", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 39, Amount = 66456, Country = "Germany", Products = "Mountain Bikes", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 91, Amount = 155064, Country = "Germany", Products = "Mountain Bikes", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 16, Amount = 27264, Country = "Germany", Products = "Mountain Bikes", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 59, Amount = 100536, Country = "Germany", Products = "Mountain Bikes", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 36, Amount = 61344, Country = "Germany", Products = "Mountain Bikes", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 39, Amount = 58466, Country = "Germany", Products = "Road Bikes", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 47, Amount = 70458, Country = "Germany", Products = "Road Bikes", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 19, Amount = 28486, Country = "Germany", Products = "Road Bikes", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 34, Amount = 50971, Country = "Germany", Products = "Road Bikes", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 34, Amount = 50971, Country = "Germany", Products = "Road Bikes", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 26, Amount = 38979, Country = "Germany", Products = "Road Bikes", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 15, Amount = 22490, Country = "Germany", Products = "Road Bikes", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 83, Amount = 124422, Country = "Germany", Products = "Road Bikes", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 79, Amount = 118426, Country = "Germany", Products = "Road Bikes", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 14, Amount = 20991, Country = "Germany", Products = "Road Bikes", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 15, Amount = 23932.5, Country = "Germany", Products = "Touring Bikes", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 47, Amount = 74988.5, Country = "Germany", Products = "Touring Bikes", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 93, Amount = 148381.5, Country = "Germany", Products = "Touring Bikes", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 13, Amount = 20741.5, Country = "Germany", Products = "Touring Bikes", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 44, Amount = 70202, Country = "Germany", Products = "Touring Bikes", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 59, Amount = 94134.5, Country = "Germany", Products = "Touring Bikes", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 34, Amount = 54247, Country = "Germany", Products = "Touring Bikes", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 48, Amount = 76584, Country = "Germany", Products = "Touring Bikes", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 35, Amount = 55842.5, Country = "Germany", Products = "Touring Bikes", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 71, Amount = 113280.5, Country = "Germany", Products = "Touring Bikes", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 77, Amount = 131208, Country = "United Kingdom", Products = "Mountain Bikes", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 92, Amount = 156768, Country = "United Kingdom", Products = "Mountain Bikes", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 51, Amount = 86904, Country = "United Kingdom", Products = "Mountain Bikes", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 91, Amount = 155064, Country = "United Kingdom", Products = "Mountain Bikes", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 90, Amount = 153360, Country = "United Kingdom", Products = "Mountain Bikes", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 56, Amount = 95424, Country = "United Kingdom", Products = "Mountain Bikes", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 14, Amount = 23856, Country = "United Kingdom", Products = "Mountain Bikes", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 95, Amount = 161880, Country = "United Kingdom", Products = "Mountain Bikes", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 24, Amount = 40896, Country = "United Kingdom", Products = "Mountain Bikes", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 39, Amount = 66456, Country = "United Kingdom", Products = "Mountain Bikes", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 84, Amount = 143136, Country = "United Kingdom", Products = "Mountain Bikes", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 40, Amount = 68160, Country = "United Kingdom", Products = "Mountain Bikes", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 96, Amount = 163584, Country = "United Kingdom", Products = "Mountain Bikes", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 24, Amount = 35981, Country = "United Kingdom", Products = "Road Bikes", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 86, Amount = 128919, Country = "United States", Products = "Road Bikes", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 31, Amount = 46474, Country = "United Kingdom", Products = "Road Bikes", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 36, Amount = 53969, Country = "United States", Products = "Road Bikes", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 40, Amount = 59965, Country = "United Kingdom", Products = "Road Bikes", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 69, Amount = 103436, Country = "United States", Products = "Road Bikes", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 95, Amount = 142410, Country = "United Kingdom", Products = "Road Bikes", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 95, Amount = 142410, Country = "United States", Products = "Road Bikes", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 30, Amount = 44975, Country = "United Kingdom", Products = "Road Bikes", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 11, Amount = 16494, Country = "United States", Products = "Road Bikes", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 97, Amount = 145408, Country = "United Kingdom", Products = "Road Bikes", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 16, Amount = 23989, Country = "United States", Products = "Road Bikes", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 40, Amount = 59965, Country = "United Kingdom", Products = "Road Bikes", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 68, Amount = 101937, Country = "United States", Products = "Road Bikes", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 11, Amount = 16494, Country = "United Kingdom", Products = "Road Bikes", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 27, Amount = 40478, Country = "United States", Products = "Road Bikes", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 45, Amount = 67460, Country = "United Kingdom", Products = "Road Bikes", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 100, Amount = 149905, Country = "United States", Products = "Road Bikes", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 70, Amount = 104935, Country = "United Kingdom", Products = "Road Bikes", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 83, Amount = 124422, Country = "United States", Products = "Road Bikes", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 100, Amount = 149905, Country = "United Kingdom", Products = "Road Bikes", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 18, Amount = 26987, Country = "United States", Products = "Road Bikes", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 70, Amount = 104935, Country = "United Kingdom", Products = "Road Bikes", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 81, Amount = 121424, Country = "United States", Products = "Road Bikes", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 20, Amount = 29985, Country = "United Kingdom", Products = "Road Bikes", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 99, Amount = 148406, Country = "United States", Products = "Road Bikes", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 43, Amount = 73272, Country = "United States", Products = "Mountain Bikes", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 43, Amount = 73272, Country = "United States", Products = "Mountain Bikes", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 52, Amount = 88608, Country = "United States", Products = "Mountain Bikes", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 91, Amount = 155064, Country = "United States", Products = "Mountain Bikes", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 37, Amount = 63048, Country = "United States", Products = "Mountain Bikes", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 41, Amount = 69864, Country = "United States", Products = "Mountain Bikes", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 49, Amount = 83496, Country = "United States", Products = "Mountain Bikes", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 23, Amount = 39192, Country = "United States", Products = "Mountain Bikes", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 67, Amount = 114168, Country = "United States", Products = "Mountain Bikes", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 85, Amount = 144840, Country = "United States", Products = "Mountain Bikes", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 25, Amount = 42600, Country = "United States", Products = "Mountain Bikes", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 28, Amount = 47712, Country = "United States", Products = "Mountain Bikes", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 53, Amount = 90312, Country = "United States", Products = "Mountain Bikes", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 82, Amount = 130831, Country = "United Kingdom", Products = "Touring Bikes", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 41, Amount = 65415.5, Country = "United States", Products = "Touring Bikes", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 60, Amount = 95730, Country = "United Kingdom", Products = "Touring Bikes", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 71, Amount = 113280.5, Country = "United States", Products = "Touring Bikes", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 45, Amount = 71797.5, Country = "United Kingdom", Products = "Touring Bikes", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 21, Amount = 33505.5, Country = "United States", Products = "Touring Bikes", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 94, Amount = 149977, Country = "United Kingdom", Products = "Touring Bikes", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 34, Amount = 54247, Country = "United States", Products = "Touring Bikes", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 14, Amount = 22337, Country = "United Kingdom", Products = "Touring Bikes", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 76, Amount = 121258, Country = "United States", Products = "Touring Bikes", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 50, Amount = 79775, Country = "United Kingdom", Products = "Touring Bikes", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 75, Amount = 119662.5, Country = "United States", Products = "Touring Bikes", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 49, Amount = 78179.5, Country = "United Kingdom", Products = "Touring Bikes", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 40, Amount = 63820, Country = "United States", Products = "Touring Bikes", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 94, Amount = 149977, Country = "United Kingdom", Products = "Touring Bikes", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 17, Amount = 27123.5, Country = "United States", Products = "Touring Bikes", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 45, Amount = 71797.5, Country = "United Kingdom", Products = "Touring Bikes", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 56, Amount = 89348, Country = "United States", Products = "Touring Bikes", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 75, Amount = 119662.5, Country = "United Kingdom", Products = "Touring Bikes", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 11, Amount = 17550.5, Country = "United States", Products = "Touring Bikes", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { Sold = 54, Amount = 86157, Country = "United Kingdom", Products = "Touring Bikes", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 14, Amount = 22337, Country = "United States", Products = "Touring Bikes", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { Sold = 11, Amount = 17550.5, Country = "United Kingdom", Products = "Touring Bikes", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 76, Amount = 121258, Country = "United States", Products = "Touring Bikes", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { Sold = 45, Amount = 71797.5, Country = "United Kingdom", Products = "Touring Bikes", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { Sold = 80, Amount = 127640, Country = "United States", Products = "Touring Bikes", Year = "FY 2018", Quarter = "Q1" });
return pivotData;
}
public class PivotData
{
public int Sold { get; set; }
public double Amount { get; set; }
public string Country { get; set; }
public string Products { get; set; }
public string Year { get; set; }
public string Quarter { get; set; }
}
@using Syncfusion.EJ2.PivotView
@Html.EJS().PivotView("pivotview").Width("100%").Height("300").ShowToolbar(true).DataSourceSettings(dataSource => dataSource.DataSource((IEnumerable<object>)ViewBag.DataSource).EnableSorting(true)
.FormatSettings(formatsettings => { formatsettings.Name("Amount").Format("C0").MaximumSignificantDigits(10).MinimumSignificantDigits(1).UseGrouping(true).Add(); })
.Rows(rows => { rows.Name("Country").Add(); rows.Name("Products").Add(); })
.Columns(columns => { columns.Name("Year").Add(); columns.Name("Order_Source").Caption("Order Source").Add(); })
.Values(values =>
{
values.Name("In_Stock").Caption("In Stock").Add(); values.Name("Sold").Caption("Units Sold").Add();
values.Name("Amount").Caption("Sold Amount").Add();
})
.Filters(filters =>
{
filters.Name("Product_Categories").Caption("Product Categories").Add();
})).GridSettings(new PivotViewGridSettings { ColumnWidth = 140 }).DisplayOption(new PivotViewDisplayOption { View = View.Both }).Toolbar(new List<string>
() { "Expand/Collapse" }).ToolbarRender("beforeToolbarRender").Render()
<style>
#pivotview {
width: 100%;
height: 100%;
}
.e-tool-expand::before {
content: '\e702';
}
</style>
<script>
function beforeToolbarRender(args) {
args.customToolbar.splice(12, 0, {
prefixIcon: 'e-tool-expand e-icons', tooltipText: 'Expand/Collapse',
click: function (args: ClickEventArgs) {
var pivotTableObj = document.getElementById('pivotview').ej2_instances[0];
pivotTableObj.dataSourceSettings.expandAll = !pivotTableObj.dataSourceSettings.expandAll;
},
});
}
</script>
public ActionResult Index()
{
var data = GetPivotData();
ViewBag.DataSource = data;
return View();
}
public List<PivotData> GetPivotData()
{
List<PivotData> pivotData = new List<PivotData>();
pivotData.Add(new PivotData { In_Stock = 34, Sold = 51, Amount = 383, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 4, Sold = 423, Amount = 3595.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 38, Sold = 234, Amount = 1813.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 42, Sold = 127, Amount = 952.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 36, Sold = 89, Amount = 668, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 17, Sold = 340, Amount = 2890, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 22, Sold = 379, Amount = 2937.25, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 12, Sold = 269, Amount = 2017.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 28, Sold = 15, Amount = 113, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 46, Sold = 369, Amount = 3136.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 16, Sold = 410, Amount = 3177.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 18, Sold = 99, Amount = 742.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 50, Sold = 50, Amount = 375.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 31, Sold = 129, Amount = 1096.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 23, Sold = 404, Amount = 3131, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 42, Sold = 132, Amount = 990, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 42, Sold = 56, Amount = 420.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 45, Sold = 481, Amount = 4088.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 3, Sold = 71, Amount = 550.25, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 35, Sold = 455, Amount = 3412.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 44, Sold = 25, Amount = 188, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 6, Sold = 466, Amount = 3961, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 47, Sold = 198, Amount = 1534.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 15, Sold = 421, Amount = 3157.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 18, Sold = 10, Amount = 75.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 6, Sold = 348, Amount = 2958, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 46, Sold = 118, Amount = 914.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 37, Sold = 207, Amount = 1552.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 17, Sold = 45, Amount = 338, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 39, Sold = 97, Amount = 824.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 3, Sold = 271, Amount = 2100.25, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 23, Sold = 501, Amount = 3757.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 42, Sold = 63, Amount = 473, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 36, Sold = 456, Amount = 3876, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 44, Sold = 155, Amount = 1201.25, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 12, Sold = 140, Amount = 1050, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 9, Sold = 31, Amount = 233, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 49, Sold = 402, Amount = 3417, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 30, Sold = 254, Amount = 1968.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 28, Sold = 314, Amount = 2355, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 43, Sold = 91, Amount = 683, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 44, Sold = 202, Amount = 1717, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 11, Sold = 298, Amount = 2309.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 39, Sold = 166, Amount = 1245, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 7, Sold = 11, Amount = 83, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 33, Sold = 416, Amount = 3536, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 39, Sold = 55, Amount = 426.25, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 16, Sold = 510, Amount = 3825, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 4, Sold = 199, Amount = 1691.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Sales Person", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 4, Sold = 103, Amount = 798.25, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "Teleshopping", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 42, Sold = 227, Amount = 1702.5, Country = "France", Product_Categories = "Accessories", Products ="Bottles and Cages", Order_Source = "App Store", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 36, Sold = 16, Amount = 72, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 18, Sold = 250, Amount = 1250, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 19, Sold = 386, Amount = 1640.5, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 40, Sold = 165, Amount = 660, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 45, Sold = 83, Amount = 373.5, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 11, Sold = 221, Amount = 1105, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 17, Sold = 249, Amount = 1058.25, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 50, Sold = 418, Amount = 1672, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 34, Sold = 55, Amount = 247.5, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 3, Sold = 415, Amount = 2075, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 42, Sold = 57, Amount = 242.25, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 5, Sold = 252, Amount = 1008, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 11, Sold = 19, Amount = 85.5, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 10, Sold = 64, Amount = 320, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 42, Sold = 66, Amount = 280.5, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 33, Sold = 263, Amount = 1052, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 41, Sold = 61, Amount = 274.5, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 33, Sold = 257, Amount = 1285, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 16, Sold = 386, Amount = 1640.5, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 10, Sold = 503, Amount = 2012, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 7, Sold = 43, Amount = 193.5, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 30, Sold = 322, Amount = 1610, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 40, Sold = 305, Amount = 1296.25, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 46, Sold = 171, Amount = 684, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 8, Sold = 22, Amount = 99, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 18, Sold = 254, Amount = 1270, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 19, Sold = 72, Amount = 306, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 37, Sold = 286, Amount = 1144, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 15, Sold = 95, Amount = 427.5, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 48, Sold = 271, Amount = 1355, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 7, Sold = 67, Amount = 284.75, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 16, Sold = 92, Amount = 368, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 18, Sold = 86, Amount = 387, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 15, Sold = 320, Amount = 1600, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 5, Sold = 244, Amount = 1037, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 45, Sold = 403, Amount = 1612, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 3, Sold = 45, Amount = 202.5, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 41, Sold = 323, Amount = 1615, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 11, Sold = 256, Amount = 1088, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 24, Sold = 361, Amount = 1444, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 47, Sold = 57, Amount = 256.5, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 2, Sold = 269, Amount = 1345, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 45, Sold = 448, Amount = 1904, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 10, Sold = 376, Amount = 1504, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 41, Sold = 15, Amount = 67.5, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 12, Sold = 157, Amount = 785, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 35, Sold = 170, Amount = 722.5, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 32, Sold = 542, Amount = 2168, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 13, Sold = 96, Amount = 432, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Retail Outlets", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 41, Sold = 212, Amount = 1060, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Sales Person", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 5, Sold = 342, Amount = 1453.5, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "Teleshopping", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 40, Sold = 84, Amount = 336, Country = "France", Product_Categories = "Accessories", Products ="Cleaners", Order_Source = "App Store", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 20, Sold = 42, Amount = 483, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 15, Sold = 287, Amount = 3444, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 14, Sold = 371, Amount = 4173.75, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 48, Sold = 414, Amount = 4554, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 43, Sold = 14, Amount = 161, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 20, Sold = 81, Amount = 972, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 48, Sold = 438, Amount = 4927.5, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 32, Sold = 507, Amount = 5577, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 45, Sold = 65, Amount = 747.5, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 41, Sold = 382, Amount = 4584, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 31, Sold = 322, Amount = 3622.5, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 6, Sold = 313, Amount = 3443, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 20, Sold = 48, Amount = 552, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 29, Sold = 345, Amount = 4140, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 15, Sold = 77, Amount = 866.25, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 32, Sold = 339, Amount = 3729, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 1, Sold = 21, Amount = 241.5, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 29, Sold = 355, Amount = 4260, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 48, Sold = 76, Amount = 855, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 16, Sold = 180, Amount = 1980, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 15, Sold = 44, Amount = 506, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 36, Sold = 453, Amount = 5436, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 33, Sold = 410, Amount = 4612.5, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 3, Sold = 163, Amount = 1793, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 36, Sold = 77, Amount = 885.5, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 9, Sold = 489, Amount = 5868, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 4, Sold = 265, Amount = 2981.25, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 33, Sold = 360, Amount = 3960, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 16, Sold = 47, Amount = 540.5, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 24, Sold = 201, Amount = 2412, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 41, Sold = 383, Amount = 4308.75, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 33, Sold = 83, Amount = 913, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 14, Sold = 24, Amount = 276, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 2, Sold = 141, Amount = 1692, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 30, Sold = 332, Amount = 3735, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 50, Sold = 253, Amount = 2783, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 34, Sold = 31, Amount = 356.5, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 37, Sold = 352, Amount = 4224, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 31, Sold = 443, Amount = 4983.75, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 50, Sold = 185, Amount = 2035, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 20, Sold = 17, Amount = 195.5, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 49, Sold = 165, Amount = 1980, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 27, Sold = 466, Amount = 5242.5, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 17, Sold = 512, Amount = 5632, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 29, Sold = 42, Amount = 483, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 29, Sold = 102, Amount = 1224, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 14, Sold = 133, Amount = 1496.25, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 36, Sold = 391, Amount = 4301, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 29, Sold = 20, Amount = 230, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Retail Outlets", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 42, Sold = 145, Amount = 1740, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Sales Person", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 16, Sold = 398, Amount = 4477.5, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "Teleshopping", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 2, Sold = 472, Amount = 5192, Country = "France", Product_Categories = "Accessories", Products ="Fenders", Order_Source = "App Store", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 24, Sold = 32, Amount = 504.96, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 40, Sold = 258, Amount = 4200.24, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 26, Sold = 442, Amount = 6864.26, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 3, Sold = 317, Amount = 4843.76, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 2, Sold = 32, Amount = 504.96, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 16, Sold = 133, Amount = 2165.24, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 40, Sold = 117, Amount = 1817.01, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 37, Sold = 129, Amount = 1971.12, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 45, Sold = 80, Amount = 1262.4, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 36, Sold = 139, Amount = 2262.92, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 18, Sold = 234, Amount = 3634.02, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 38, Sold = 444, Amount = 6784.32, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 36, Sold = 60, Amount = 946.8, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 15, Sold = 470, Amount = 7651.6, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 27, Sold = 448, Amount = 6957.44, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 17, Sold = 118, Amount = 1803.04, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 7, Sold = 15, Amount = 236.7, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 45, Sold = 95, Amount = 1546.6, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 35, Sold = 191, Amount = 2966.23, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 16, Sold = 426, Amount = 6509.28, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 35, Sold = 78, Amount = 1230.84, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 3, Sold = 69, Amount = 1123.32, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 31, Sold = 221, Amount = 3432.13, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 13, Sold = 285, Amount = 4354.8, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 26, Sold = 56, Amount = 883.68, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 17, Sold = 303, Amount = 4932.84, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 34, Sold = 419, Amount = 6507.07, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 26, Sold = 397, Amount = 6066.16, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 14, Sold = 90, Amount = 1420.2, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 7, Sold = 337, Amount = 5486.36, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 47, Sold = 74, Amount = 1149.22, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 26, Sold = 203, Amount = 3101.84, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 10, Sold = 83, Amount = 1309.74, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 29, Sold = 152, Amount = 2474.56, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 30, Sold = 144, Amount = 2236.32, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 25, Sold = 231, Amount = 3529.68, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 31, Sold = 47, Amount = 741.66, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 29, Sold = 464, Amount = 7553.92, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 3, Sold = 460, Amount = 7143.8, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 27, Sold = 343, Amount = 5241.04, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 6, Sold = 22, Amount = 347.16, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 20, Sold = 161, Amount = 2621.08, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 4, Sold = 188, Amount = 2919.64, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 26, Sold = 233, Amount = 3560.24, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 26, Sold = 17, Amount = 268.26, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 39, Sold = 121, Amount = 1969.88, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 49, Sold = 469, Amount = 7283.57, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 31, Sold = 297, Amount = 4538.16, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 4, Sold = 30, Amount = 473.4, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Retail Outlets", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 11, Sold = 288, Amount = 4688.64, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Sales Person", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 8, Sold = 155, Amount = 2407.15, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "Teleshopping", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 7, Sold = 121, Amount = 1848.88, Country = "France", Product_Categories = "Accessories", Products ="Helmets", Order_Source = "App Store", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 16, Sold = 46, Amount = 1414.5, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 3, Sold = 328, Amount = 10250, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 32, Sold = 393, Amount = 11986.5, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 49, Sold = 415, Amount = 12553.75, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 37, Sold = 63, Amount = 1937.25, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 6, Sold = 411, Amount = 12843.75, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 19, Sold = 106, Amount = 3233, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 10, Sold = 222, Amount = 6715.5, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 43, Sold = 98, Amount = 3013.5, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 27, Sold = 59, Amount = 1843.75, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 18, Sold = 355, Amount = 10827.5, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 12, Sold = 76, Amount = 2299, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 16, Sold = 38, Amount = 1168.5, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 47, Sold = 189, Amount = 5906.25, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 16, Sold = 458, Amount = 13969, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 19, Sold = 436, Amount = 13189, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 38, Sold = 19, Amount = 584.25, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 2, Sold = 444, Amount = 13875, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 33, Sold = 186, Amount = 5673, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 3, Sold = 225, Amount = 6806.25, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 26, Sold = 11, Amount = 338.25, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 16, Sold = 61, Amount = 1906.25, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 24, Sold = 272, Amount = 8296, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 44, Sold = 150, Amount = 4537.5, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 11, Sold = 51, Amount = 1568.25, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 32, Sold = 490, Amount = 15312.5, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 41, Sold = 487, Amount = 14853.5, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 36, Sold = 184, Amount = 5566, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 9, Sold = 24, Amount = 738, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 50, Sold = 101, Amount = 3156.25, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 39, Sold = 301, Amount = 9180.5, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 25, Sold = 506, Amount = 15306.5, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 1, Sold = 89, Amount = 2736.75, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 1, Sold = 80, Amount = 2500, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 37, Sold = 196, Amount = 5978, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 36, Sold = 103, Amount = 3115.75, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 20, Sold = 35, Amount = 1076.25, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 47, Sold = 159, Amount = 4968.75, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 45, Sold = 392, Amount = 11956, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 30, Sold = 438, Amount = 13249.5, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 31, Sold = 75, Amount = 2306.25, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 40, Sold = 383, Amount = 11968.75, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 43, Sold = 160, Amount = 4880, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 29, Sold = 378, Amount = 11434.5, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 50, Sold = 18, Amount = 553.5, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 17, Sold = 140, Amount = 4375, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 18, Sold = 258, Amount = 7869, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 19, Sold = 508, Amount = 15367, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 11, Sold = 59, Amount = 1814.25, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Retail Outlets", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 29, Sold = 83, Amount = 2593.75, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Sales Person", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 37, Sold = 414, Amount = 12627, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "Teleshopping", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 49, Sold = 341, Amount = 10315.25, Country = "France", Product_Categories = "Accessories", Products ="Hydration Packs", Order_Source = "App Store", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 2, Sold = 48, Amount = 936, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 12, Sold = 174, Amount = 3480, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 14, Sold = 202, Amount = 3888.5, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 9, Sold = 469, Amount = 8911, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 11, Sold = 53, Amount = 1033.5, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 19, Sold = 74, Amount = 1480, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 5, Sold = 467, Amount = 8989.75, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 40, Sold = 322, Amount = 6118, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 8, Sold = 53, Amount = 1033.5, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 22, Sold = 468, Amount = 9360, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 12, Sold = 277, Amount = 5332.25, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 31, Sold = 236, Amount = 4484, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 7, Sold = 49, Amount = 955.5, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 24, Sold = 191, Amount = 3820, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 32, Sold = 165, Amount = 3176.25, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 28, Sold = 185, Amount = 3515, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 5, Sold = 92, Amount = 1794, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 44, Sold = 128, Amount = 2560, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 33, Sold = 258, Amount = 4966.5, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 24, Sold = 274, Amount = 5206, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 25, Sold = 58, Amount = 1131, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 7, Sold = 322, Amount = 6440, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 44, Sold = 168, Amount = 3234, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 7, Sold = 120, Amount = 2280, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 8, Sold = 18, Amount = 351, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 23, Sold = 142, Amount = 2840, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 4, Sold = 133, Amount = 2560.25, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 10, Sold = 377, Amount = 7163, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 1, Sold = 56, Amount = 1092, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 22, Sold = 318, Amount = 6360, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 8, Sold = 456, Amount = 8778, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 21, Sold = 408, Amount = 7752, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 33, Sold = 34, Amount = 663, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 47, Sold = 226, Amount = 4520, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 4, Sold = 355, Amount = 6833.75, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 45, Sold = 237, Amount = 4503, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 34, Sold = 94, Amount = 1833, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 41, Sold = 273, Amount = 5460, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 2, Sold = 280, Amount = 5390, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 31, Sold = 146, Amount = 2774, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 17, Sold = 37, Amount = 721.5, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 40, Sold = 219, Amount = 4380, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 29, Sold = 497, Amount = 9567.25, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 31, Sold = 378, Amount = 7182, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 15, Sold = 83, Amount = 1618.5, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 24, Sold = 211, Amount = 4220, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 42, Sold = 372, Amount = 7161, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 8, Sold = 537, Amount = 10203, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 8, Sold = 58, Amount = 1131, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Retail Outlets", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 25, Sold = 155, Amount = 3100, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Sales Person", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 17, Sold = 211, Amount = 4061.75, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "Teleshopping", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 1, Sold = 134, Amount = 2546, Country = "France", Product_Categories = "Accessories", Products ="Tires and Tubes", Order_Source = "App Store", Year = "FY 2018", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 18, Sold = 58, Amount = 98832, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 8, Sold = 474, Amount = 810066, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 43, Sold = 447, Amount = 762582, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 12, Sold = 289, Amount = 491011, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 43, Sold = 60, Amount = 102240, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 29, Sold = 93, Amount = 158937, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 11, Sold = 96, Amount = 163776, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 29, Sold = 401, Amount = 681299, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 42, Sold = 83, Amount = 141432, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 21, Sold = 427, Amount = 729743, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 33, Sold = 396, Amount = 675576, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 11, Sold = 98, Amount = 166502, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 29, Sold = 48, Amount = 81792, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Retail Outlets", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 31, Sold = 288, Amount = 492192, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Sales Person", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 40, Sold = 352, Amount = 600512, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Teleshopping", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 12, Sold = 426, Amount = 723774, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "App Store", Year = "FY 2015", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 19, Sold = 85, Amount = 144840, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 18, Sold = 432, Amount = 738288, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 14, Sold = 267, Amount = 455502, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 33, Sold = 434, Amount = 737366, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 24, Sold = 39, Amount = 66456, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 39, Sold = 171, Amount = 292239, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 20, Sold = 304, Amount = 518624, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 13, Sold = 441, Amount = 749259, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 16, Sold = 68, Amount = 115872, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 2, Sold = 406, Amount = 693854, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 10, Sold = 50, Amount = 85300, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 40, Sold = 231, Amount = 392469, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 31, Sold = 31, Amount = 52824, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Retail Outlets", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 34, Sold = 254, Amount = 434086, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Sales Person", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 38, Sold = 455, Amount = 776230, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Teleshopping", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 39, Sold = 304, Amount = 516496, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "App Store", Year = "FY 2016", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 50, Sold = 40, Amount = 68160, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 23, Sold = 204, Amount = 348636, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 26, Sold = 231, Amount = 394086, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 30, Sold = 531, Amount = 902169, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q1" });
pivotData.Add(new PivotData { In_Stock = 35, Sold = 45, Amount = 76680, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 8, Sold = 275, Amount = 469975, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 42, Sold = 292, Amount = 498152, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 25, Sold = 197, Amount = 334703, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q2" });
pivotData.Add(new PivotData { In_Stock = 8, Sold = 35, Amount = 59640, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 31, Sold = 234, Amount = 399906, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 34, Sold = 127, Amount = 216662, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 44, Sold = 377, Amount = 640523, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "App Store", Year = "FY 2017", Quarter = "Q3" });
pivotData.Add(new PivotData { In_Stock = 31, Sold = 40, Amount = 68160, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Retail Outlets", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 33, Sold = 474, Amount = 810066, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Sales Person", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 49, Sold = 168, Amount = 286608, Country = "France", Product_Categories = "Bikes", Products ="Mountain Bikes", Order_Source = "Teleshopping", Year = "FY 2017", Quarter = "Q4" });
pivotData.Add(new PivotData { In_Stock = 43, Sold = 521, Amount = 885179, Country = "France", Product_Categories = "Bikes"