Search results

Tooltip in ASP.NET Core 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.

tagHelper
ToolTip.cs
Copied to clipboard
<ejs-pivotview id="PivotView" height="300" showTooltip="false">
    <e-datasourcesettings dataSource="@ViewBag.DataSource" expandAll="false">
        <e-formatsettings>
            <e-field name="Amount" format="C0" maximumSignificantDigits="10" minimumSignificantDigits="1" useGrouping="true"></e-field>
        </e-formatsettings>
        <e-rows>
            <e-field name="Country"></e-field>
            <e-field name="Products"></e-field>
        </e-rows>
        <e-columns>
            <e-field name="Year" caption="Year"></e-field>
            <e-field name="Quarter"></e-field>
        </e-columns>
        <e-values>
            <e-field name="Sold" caption="Units Sold"></e-field>
            <e-field name="Amount" caption="Sold Amount"></e-field>
        </e-values>
    </e-datasourcesettings>
</ejs-pivotview>
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; }
}

Tooltip Template

User can design their own tooltip by setting the property tooltipTemplate with own HTML elements. The property accepts both HTML string and ID attribute. The following place holders are available to display its dynamic values inside the HTML elements.

${rowHeaders} – Row headers of the selected value cell.

${columnHeaders} – Column headers of the selected value cell.

${rowFields} – Row fields of the selected value cell.

${columnFields} – Column fields of the selected value cell.

${valueField} – Field name of the selected value cell.

${aggregateType} – Aggregate type of the selected value cell.

${value} - Formatted value of the selected value cell.

The tooltip customization is common for both pivot table and pivot chart or it can be done individually as well. To customize the pivot table tooltip, the above procedure needs to be followed. To customize the pivot chart tooltip alone use template property of tooltip under e-chartSettings.

In the below sample, the pivot table and pivot chart shows customized tooltip layouts.

tagHelper
tooltip-template.cs
Copied to clipboard
<ejs-pivotview id="pivotview" showToolbar="true" tooltipTemplate="#Template" width="100%" height="300" toolbar="@(new List<string>() {"Grid", "Chart" })" >
    <e-datasourcesettings dataSource="@ViewBag.DataSource" expandAll="false" enableSorting="true">
        <e-formatsettings>
            <e-field name="Amount" format="C0" maximumSignificantDigits="10" minimumSignificantDigits="1" useGrouping="true"></e-field>
        </e-formatsettings>
        <e-rows>
            <e-field name="Country"></e-field>
            <e-field name="Products"></e-field>
        </e-rows>
        <e-columns>
            <e-field name="Year"></e-field>
            <e-field name="Order_Source" caption="Order Source"></e-field>
        </e-columns>
        <e-values>
            <e-field name="In_Stock" caption="In Stock"></e-field>
            <e-field name="Sold" caption="Units Sold"></e-field>
            <e-field name="Amount" caption="Sold Amount"></e-field>
        </e-values>
        <e-filters>
            <e-field name="Product_Categories" caption="Product Categories"></e-field>
        </e-filters>
    </e-datasourcesettings>
    <e-gridSettings columnWidth="140"></e-gridSettings>
    <e-chartSettings>
        <e-chartSeries type="Column"></e-chartSeries>
        <e-tooltip enableMarker="true" template="<span class='wrap'>${aggregateType} of ${valueField}: ${value}</span>">
        </e-tooltip>
    </e-chartSettings>
    <e-displayOption view="Both"></e-displayOption>
</ejs-pivotview>
<style>
    #pivotview {
        width: 100%;
        height: 100%;
    }

    .e-tool-expand::before {
        content: '\e702';
    }

    .wrap {
        border: 3px solid #27b1f0;
        background-color: #4d4d4d;
        width: auto;
        color: #FFFFFF;
        padding: 5px;
        font-size: 12px;
    }

    .pivotTooltipValue {
        font-style: italic;
    }

    .pivotTooltipHeader {
        color: aqua;
        font-weight: bold;
        width: 100px;
    }
</style>
<script id="Template" type="text/x-template">
        <div class='wrap'>
                    <div>
                        <span class='pivotTooltipHeader'>Row Headers :</span > 
                        <span class='pivotTooltipValue'>${columnHeaders}${rowHeaders}</span >
                    </div>
                    <div>
                        <span class='pivotTooltipHeader'>Row Fields : </span>
                        <span class='pivotTooltipValue'>${rowFields}</span>
                    </div>
                    <div>
                        <span class='pivotTooltipHeader'>Column Headers :</span >
                        <span class='pivotTooltipValue'>${columnHeaders}</span>
                    </div>
                    <div>
                        <span class='pivotTooltipHeader'>Column Fields :</span> 
                        <span class='pivotTooltipValue'>${columnFields}</span>
                    </div>
                    <div>
                        <span class='pivotTooltipHeader'>Value Field :</span> 
                        <span class='pivotTooltipValue'>${valueField}</span>
                    </div>
                    <div>
                        <span class='pivotTooltipHeader'>Value : </span>
                        <span class='pivotTooltipValue'>${value}</span>
                    </div>
        </div>
</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 =