Search results

Tooltip in ASP.NET MVC Pivot Table control

14 Apr 2021 / 2 minutes to read

The tooltip can be enabled or disabled by setting the showTooltip property to true. By default, tooltip is enabled in the pivot table.

razor
ToolTip.cs
Copied to clipboard
@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()
Copied to clipboard
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; }
}
razor
ToolbarCustomize.cs
Copied to clipboard
@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>
Copied to clipboard
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"