Blazor Pivot Grid Features

The pivot and flat grid components inherit from a common base and thus share some functionality and features.

Some features do not have meaningful behavior in the context of a pivot table and therefore cannot be enabled for IgbPivotGrid. These include: CRUD operations Grouping Row/Column Pinning Summaries Paging

The Pivot Grid component has additional features and functionalities related to its dimensions as described below.

EXAMPLE

MODULES

DATA

RAZOR

JS

CSS

using System;
using System.Net.Http;
using System.Collections.Generic;
using System.Threading.Tasks;
using System.Text;
using Microsoft.AspNetCore.Components.WebAssembly.Hosting;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Logging;
using IgniteUI.Blazor.Controls; // for registering Ignite UI modules

namespace Infragistics.Samples
{
    public class Program
    {
        public static async Task Main(string[] args)
        {
            var builder = WebAssemblyHostBuilder.CreateDefault(args);
            builder.RootComponents.Add<App>("app");
            builder.Services.AddScoped(sp => new HttpClient { BaseAddress = new Uri(builder.HostEnvironment.BaseAddress) });
            // registering Ignite UI modules
            builder.Services.AddIgniteUIBlazor(
                typeof(IgbPivotGridModule)
            );
            await builder.Build().RunAsync();
        }
    }
}csCOPY CODE

using System;
using System.Collections.Generic;
public class PivotDataFlatItem
{
    public string ProductName { get; set; }
    public double ProductUnitPrice { get; set; }
    public string SellerName { get; set; }
    public string SellerCity { get; set; }
    public string Date { get; set; }
    public double Value { get; set; }
    public double NumberOfUnits { get; set; }
}

public class PivotDataFlat
    : List<PivotDataFlatItem>
{
    public PivotDataFlat()
    {
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 12.8, SellerName = @"Stanley Brooker", SellerCity = @"Seattle", Date = @"01/01/2007", Value = 94.4, NumberOfUnits = 282 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 49.6, SellerName = @"Elisa Longbottom", SellerCity = @"Sofia", Date = @"01/05/2007", Value = 70.8, NumberOfUnits = 296 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 3.6, SellerName = @"Lydia Burson", SellerCity = @"Tokyo", Date = @"01/06/2007", Value = 35.8, NumberOfUnits = 68 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 85.6, SellerName = @"David Haley", SellerCity = @"London", Date = @"01/07/2007", Value = 41.4, NumberOfUnits = 293 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 18.2, SellerName = @"John Smith", SellerCity = @"Seattle", Date = @"01/08/2007", Value = 60.6, NumberOfUnits = 240 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 68.4, SellerName = @"Larry Lieb", SellerCity = @"Tokyo", Date = @"01/12/2007", Value = 38, NumberOfUnits = 456 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 16.2, SellerName = @"Walter Pang", SellerCity = @"Sofia", Date = @"02/09/2007", Value = 89.2, NumberOfUnits = 492 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 35.2, SellerName = @"Benjamin Dupree", SellerCity = @"Tokyo", Date = @"02/16/2007", Value = 2, NumberOfUnits = 78 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 73.2, SellerName = @"Nicholas Carmona", SellerCity = @"Mellvile", Date = @"02/17/2007", Value = 4.6, NumberOfUnits = 150 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 73.6, SellerName = @"Nicholas Carmona", SellerCity = @"London", Date = @"02/19/2007", Value = 36.2, NumberOfUnits = 262 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 47.2, SellerName = @"Monica Freitag", SellerCity = @"Sofia", Date = @"02/21/2007", Value = 18.8, NumberOfUnits = 125 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 51.4, SellerName = @"Kathe Pettel", SellerCity = @"Sofia", Date = @"03/04/2007", Value = 11.6, NumberOfUnits = 42 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 27.6, SellerName = @"David Haley", SellerCity = @"Tokyo", Date = @"03/04/2007", Value = 41.4, NumberOfUnits = 282 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 22.4, SellerName = @"Antonio Charbonneau", SellerCity = @"Berlin", Date = @"03/17/2007", Value = 59.8, NumberOfUnits = 305 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 85.4, SellerName = @"Glenn Landeros", SellerCity = @"Tokyo", Date = @"03/23/2007", Value = 31.4, NumberOfUnits = 265 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 80.8, SellerName = @"Elisa Longbottom", SellerCity = @"Mellvile", Date = @"03/25/2007", Value = 90.4, NumberOfUnits = 350 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 64.6, SellerName = @"Glenn Landeros", SellerCity = @"Mellvile", Date = @"03/27/2007", Value = 95.4, NumberOfUnits = 82 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 50, SellerName = @"Harry Tyler", SellerCity = @"New York", Date = @"04/02/2007", Value = 1.4, NumberOfUnits = 67 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 16.4, SellerName = @"Brandon Mckim", SellerCity = @"Mellvile", Date = @"04/04/2007", Value = 25.4, NumberOfUnits = 370 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 50, SellerName = @"Monica Freitag", SellerCity = @"Berlin", Date = @"04/12/2007", Value = 46.4, NumberOfUnits = 228 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 44.8, SellerName = @"Bryan Culver", SellerCity = @"Tokyo", Date = @"04/15/2007", Value = 82.2, NumberOfUnits = 272 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 44.4, SellerName = @"Russell Shorter", SellerCity = @"Berlin", Date = @"04/18/2007", Value = 84, NumberOfUnits = 227 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 39.4, SellerName = @"Stanley Brooker", SellerCity = @"Mellvile", Date = @"04/18/2007", Value = 94.4, NumberOfUnits = 248 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 36.6, SellerName = @"Benjamin Meekins", SellerCity = @"Tokyo", Date = @"04/21/2007", Value = 45.8, NumberOfUnits = 414 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 75.8, SellerName = @"Walter Pang", SellerCity = @"London", Date = @"04/25/2007", Value = 97.6, NumberOfUnits = 43 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 57.8, SellerName = @"Antonio Charbonneau", SellerCity = @"Mellvile", Date = @"04/26/2007", Value = 21, NumberOfUnits = 71 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 40.2, SellerName = @"Stanley Brooker", SellerCity = @"New York", Date = @"05/14/2007", Value = 72, NumberOfUnits = 321 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 49.6, SellerName = @"Elisa Longbottom", SellerCity = @"London", Date = @"05/17/2007", Value = 49.6, NumberOfUnits = 329 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 56.6, SellerName = @"Benjamin Dupree", SellerCity = @"London", Date = @"05/17/2007", Value = 72.8, NumberOfUnits = 88 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 67.2, SellerName = @"Glenn Landeros", SellerCity = @"New York", Date = @"05/26/2007", Value = 56.2, NumberOfUnits = 366 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 14.6, SellerName = @"Walter Pang", SellerCity = @"Sofia", Date = @"06/02/2007", Value = 81.4, NumberOfUnits = 450 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 89.4, SellerName = @"Howard Sprouse", SellerCity = @"Seattle", Date = @"06/06/2007", Value = 19, NumberOfUnits = 475 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 33.8, SellerName = @"Nicholas Carmona", SellerCity = @"Seattle", Date = @"06/11/2007", Value = 55, NumberOfUnits = 195 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 54.2, SellerName = @"Harold Garvin", SellerCity = @"Sofia", Date = @"06/17/2007", Value = 71.6, NumberOfUnits = 458 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 18.4, SellerName = @"Benjamin Dupree", SellerCity = @"Sofia", Date = @"07/04/2007", Value = 24.2, NumberOfUnits = 7 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 96.2, SellerName = @"Elisa Longbottom", SellerCity = @"New York", Date = @"07/08/2007", Value = 57.6, NumberOfUnits = 158 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 23, SellerName = @"Benjamin Meekins", SellerCity = @"Tokyo", Date = @"07/09/2007", Value = 58.8, NumberOfUnits = 34 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 52.8, SellerName = @"Larry Lieb", SellerCity = @"Seattle", Date = @"07/10/2007", Value = 32.4, NumberOfUnits = 412 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 62.2, SellerName = @"John Smith", SellerCity = @"Sofia", Date = @"07/15/2007", Value = 85, NumberOfUnits = 10 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 10.8, SellerName = @"Antonio Charbonneau", SellerCity = @"New York", Date = @"07/16/2007", Value = 52.2, NumberOfUnits = 466 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 4.8, SellerName = @"Stanley Brooker", SellerCity = @"London", Date = @"07/20/2007", Value = 34.2, NumberOfUnits = 248 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 43.8, SellerName = @"Brandon Mckim", SellerCity = @"Mellvile", Date = @"07/24/2007", Value = 45.6, NumberOfUnits = 307 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 76.4, SellerName = @"Glenn Landeros", SellerCity = @"London", Date = @"07/26/2007", Value = 26.2, NumberOfUnits = 445 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 34.4, SellerName = @"Bryan Culver", SellerCity = @"New York", Date = @"08/01/2007", Value = 89.2, NumberOfUnits = 480 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 68.6, SellerName = @"Howard Sprouse", SellerCity = @"Berlin", Date = @"08/02/2007", Value = 38.2, NumberOfUnits = 390 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 65.2, SellerName = @"Larry Lieb", SellerCity = @"Mellvile", Date = @"08/05/2007", Value = 23.2, NumberOfUnits = 388 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 45, SellerName = @"Russell Shorter", SellerCity = @"Seattle", Date = @"08/19/2007", Value = 23.4, NumberOfUnits = 37 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 93.6, SellerName = @"John Smith", SellerCity = @"New York", Date = @"08/24/2007", Value = 17.4, NumberOfUnits = 237 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 94.4, SellerName = @"Harry Tyler", SellerCity = @"Seattle", Date = @"08/26/2007", Value = 54.6, NumberOfUnits = 396 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 72.4, SellerName = @"David Haley", SellerCity = @"Tokyo", Date = @"08/26/2007", Value = 61, NumberOfUnits = 3 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 80.6, SellerName = @"Russell Shorter", SellerCity = @"New York", Date = @"09/02/2007", Value = 85.2, NumberOfUnits = 330 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 65.4, SellerName = @"Benjamin Dupree", SellerCity = @"London", Date = @"09/04/2007", Value = 51.2, NumberOfUnits = 143 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 30.6, SellerName = @"Bryan Culver", SellerCity = @"Seattle", Date = @"09/05/2007", Value = 55.2, NumberOfUnits = 318 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 7.6, SellerName = @"Alfredo Fetuchini", SellerCity = @"Seattle", Date = @"09/06/2007", Value = 41.8, NumberOfUnits = 393 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 47, SellerName = @"Harold Garvin", SellerCity = @"Seattle", Date = @"09/10/2007", Value = 9.2, NumberOfUnits = 129 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 38, SellerName = @"Glenn Landeros", SellerCity = @"London", Date = @"09/17/2007", Value = 25.6, NumberOfUnits = 426 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 2.6, SellerName = @"Harry Tyler", SellerCity = @"London", Date = @"09/18/2007", Value = 36.4, NumberOfUnits = 217 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 77.6, SellerName = @"John Smith", SellerCity = @"New York", Date = @"09/20/2007", Value = 28, NumberOfUnits = 152 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 97.2, SellerName = @"Benjamin Meekins", SellerCity = @"Seattle", Date = @"09/25/2007", Value = 21.8, NumberOfUnits = 452 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 19.8, SellerName = @"Carl Costello", SellerCity = @"Seattle", Date = @"10/02/2007", Value = 98.4, NumberOfUnits = 499 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 32.8, SellerName = @"Mark Slater", SellerCity = @"Seattle", Date = @"10/06/2007", Value = 79.6, NumberOfUnits = 169 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 22, SellerName = @"Nicholas Carmona", SellerCity = @"Berlin", Date = @"10/14/2007", Value = 69.6, NumberOfUnits = 386 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 35.6, SellerName = @"Russell Shorter", SellerCity = @"Sofia", Date = @"10/14/2007", Value = 27.8, NumberOfUnits = 454 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 47, SellerName = @"Elisa Longbottom", SellerCity = @"New York", Date = @"10/25/2007", Value = 82.2, NumberOfUnits = 334 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 41.2, SellerName = @"Lydia Burson", SellerCity = @"Tokyo", Date = @"10/26/2007", Value = 54.4, NumberOfUnits = 107 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 13.8, SellerName = @"Mark Slater", SellerCity = @"Sofia", Date = @"11/07/2007", Value = 86.2, NumberOfUnits = 275 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 64.2, SellerName = @"Monica Freitag", SellerCity = @"London", Date = @"11/09/2007", Value = 37.8, NumberOfUnits = 241 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 1.2, SellerName = @"Larry Lieb", SellerCity = @"London", Date = @"11/11/2007", Value = 75.2, NumberOfUnits = 177 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 57.8, SellerName = @"Monica Freitag", SellerCity = @"Sofia", Date = @"11/13/2007", Value = 58.6, NumberOfUnits = 494 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 39.6, SellerName = @"Lydia Burson", SellerCity = @"Mellvile", Date = @"11/19/2007", Value = 40.8, NumberOfUnits = 451 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 5.2, SellerName = @"Stanley Brooker", SellerCity = @"Tokyo", Date = @"01/01/2008", Value = 91.8, NumberOfUnits = 125 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 53.4, SellerName = @"Kathe Pettel", SellerCity = @"London", Date = @"01/02/2008", Value = 31, NumberOfUnits = 103 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 52.2, SellerName = @"Larry Lieb", SellerCity = @"New York", Date = @"01/03/2008", Value = 43, NumberOfUnits = 224 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 17.8, SellerName = @"Nicholas Carmona", SellerCity = @"Mellvile", Date = @"01/07/2008", Value = 47.6, NumberOfUnits = 498 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 80.8, SellerName = @"Benjamin Dupree", SellerCity = @"London", Date = @"01/08/2008", Value = 15.6, NumberOfUnits = 142 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 95.4, SellerName = @"Larry Lieb", SellerCity = @"Berlin", Date = @"01/21/2008", Value = 87.2, NumberOfUnits = 487 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 21.8, SellerName = @"David Haley", SellerCity = @"Mellvile", Date = @"01/27/2008", Value = 14.6, NumberOfUnits = 331 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 30, SellerName = @"Glenn Landeros", SellerCity = @"London", Date = @"02/03/2008", Value = 99.2, NumberOfUnits = 418 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 39.8, SellerName = @"Benjamin Meekins", SellerCity = @"New York", Date = @"02/04/2008", Value = 61, NumberOfUnits = 214 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 40.4, SellerName = @"Elisa Longbottom", SellerCity = @"Mellvile", Date = @"02/05/2008", Value = 81.8, NumberOfUnits = 229 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 35.2, SellerName = @"Alfredo Fetuchini", SellerCity = @"London", Date = @"02/05/2008", Value = 54.4, NumberOfUnits = 16 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 41.8, SellerName = @"Harry Tyler", SellerCity = @"Sofia", Date = @"02/08/2008", Value = 18, NumberOfUnits = 216 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 0.8, SellerName = @"Harry Tyler", SellerCity = @"Sofia", Date = @"02/09/2008", Value = 85, NumberOfUnits = 486 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 37.6, SellerName = @"Elisa Longbottom", SellerCity = @"Tokyo", Date = @"02/13/2008", Value = 45.2, NumberOfUnits = 172 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 20.8, SellerName = @"Antonio Charbonneau", SellerCity = @"New York", Date = @"02/21/2008", Value = 60.6, NumberOfUnits = 102 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 70.8, SellerName = @"Kathe Pettel", SellerCity = @"Seattle", Date = @"02/24/2008", Value = 43, NumberOfUnits = 36 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 53.4, SellerName = @"Alfredo Fetuchini", SellerCity = @"Mellvile", Date = @"02/25/2008", Value = 11, NumberOfUnits = 71 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 25, SellerName = @"Alfredo Fetuchini", SellerCity = @"Mellvile", Date = @"02/25/2008", Value = 17, NumberOfUnits = 53 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 64.6, SellerName = @"Antonio Charbonneau", SellerCity = @"Tokyo", Date = @"02/25/2008", Value = 99, NumberOfUnits = 104 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 9.6, SellerName = @"Brandon Mckim", SellerCity = @"Tokyo", Date = @"02/26/2008", Value = 96.2, NumberOfUnits = 294 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 41.2, SellerName = @"Antonio Charbonneau", SellerCity = @"Sofia", Date = @"03/03/2008", Value = 93.8, NumberOfUnits = 454 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 37, SellerName = @"Stanley Brooker", SellerCity = @"Berlin", Date = @"03/05/2008", Value = 82.8, NumberOfUnits = 492 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 16.8, SellerName = @"Harry Tyler", SellerCity = @"New York", Date = @"03/08/2008", Value = 0.8, NumberOfUnits = 132 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 24.8, SellerName = @"Alfredo Fetuchini", SellerCity = @"New York", Date = @"03/09/2008", Value = 88.6, NumberOfUnits = 225 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 65.6, SellerName = @"David Haley", SellerCity = @"Tokyo", Date = @"03/10/2008", Value = 69.2, NumberOfUnits = 422 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 70.6, SellerName = @"Glenn Landeros", SellerCity = @"London", Date = @"03/12/2008", Value = 97.2, NumberOfUnits = 303 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 65.2, SellerName = @"Carl Costello", SellerCity = @"London", Date = @"03/13/2008", Value = 46.4, NumberOfUnits = 319 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 39.6, SellerName = @"Harold Garvin", SellerCity = @"London", Date = @"03/14/2008", Value = 48.6, NumberOfUnits = 262 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 50.8, SellerName = @"Harold Garvin", SellerCity = @"Berlin", Date = @"03/23/2008", Value = 91.8, NumberOfUnits = 345 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 88.4, SellerName = @"David Haley", SellerCity = @"Tokyo", Date = @"04/03/2008", Value = 87.4, NumberOfUnits = 407 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 47.4, SellerName = @"Walter Pang", SellerCity = @"Berlin", Date = @"04/04/2008", Value = 15.2, NumberOfUnits = 121 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 30.4, SellerName = @"Larry Lieb", SellerCity = @"Seattle", Date = @"04/06/2008", Value = 44.4, NumberOfUnits = 30 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 88.2, SellerName = @"Harold Garvin", SellerCity = @"Berlin", Date = @"04/11/2008", Value = 25.4, NumberOfUnits = 293 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 16.6, SellerName = @"David Haley", SellerCity = @"Sofia", Date = @"04/12/2008", Value = 55.2, NumberOfUnits = 271 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 95.2, SellerName = @"Howard Sprouse", SellerCity = @"Sofia", Date = @"04/18/2008", Value = 25.8, NumberOfUnits = 107 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 7.8, SellerName = @"Bryan Culver", SellerCity = @"Mellvile", Date = @"04/18/2008", Value = 54.6, NumberOfUnits = 87 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 94.8, SellerName = @"David Haley", SellerCity = @"Tokyo", Date = @"04/23/2008", Value = 79, NumberOfUnits = 319 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 37.2, SellerName = @"Lydia Burson", SellerCity = @"New York", Date = @"04/24/2008", Value = 21.6, NumberOfUnits = 346 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 99.4, SellerName = @"Benjamin Dupree", SellerCity = @"London", Date = @"05/07/2008", Value = 77.8, NumberOfUnits = 382 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 96.2, SellerName = @"Larry Lieb", SellerCity = @"New York", Date = @"05/11/2008", Value = 35.4, NumberOfUnits = 334 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 26.2, SellerName = @"Harold Garvin", SellerCity = @"Tokyo", Date = @"05/13/2008", Value = 28.8, NumberOfUnits = 176 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 80.8, SellerName = @"Mark Slater", SellerCity = @"Berlin", Date = @"05/19/2008", Value = 8.4, NumberOfUnits = 125 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 78.4, SellerName = @"Russell Shorter", SellerCity = @"Mellvile", Date = @"05/19/2008", Value = 15, NumberOfUnits = 458 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 94, SellerName = @"Benjamin Meekins", SellerCity = @"Berlin", Date = @"05/25/2008", Value = 68.6, NumberOfUnits = 331 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 96.6, SellerName = @"Stanley Brooker", SellerCity = @"Mellvile", Date = @"05/27/2008", Value = 71, NumberOfUnits = 39 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 37.6, SellerName = @"Claudia Kobayashi", SellerCity = @"London", Date = @"06/06/2008", Value = 97.2, NumberOfUnits = 238 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 47, SellerName = @"Walter Pang", SellerCity = @"London", Date = @"06/07/2008", Value = 5.8, NumberOfUnits = 84 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 80.2, SellerName = @"Mark Slater", SellerCity = @"Tokyo", Date = @"06/08/2008", Value = 24.8, NumberOfUnits = 363 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 43.6, SellerName = @"Harry Tyler", SellerCity = @"New York", Date = @"06/08/2008", Value = 59, NumberOfUnits = 479 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 56.4, SellerName = @"Kathe Pettel", SellerCity = @"Sofia", Date = @"06/11/2008", Value = 87.6, NumberOfUnits = 404 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 81.8, SellerName = @"Glenn Landeros", SellerCity = @"London", Date = @"06/18/2008", Value = 80.4, NumberOfUnits = 478 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 90.2, SellerName = @"Benjamin Meekins", SellerCity = @"Sofia", Date = @"06/19/2008", Value = 2.4, NumberOfUnits = 285 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 99.4, SellerName = @"Kathe Pettel", SellerCity = @"Sofia", Date = @"06/22/2008", Value = 82.6, NumberOfUnits = 15 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 30.8, SellerName = @"Brandon Mckim", SellerCity = @"Berlin", Date = @"06/26/2008", Value = 77.8, NumberOfUnits = 245 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 99.4, SellerName = @"Nicholas Carmona", SellerCity = @"Mellvile", Date = @"07/01/2008", Value = 8.2, NumberOfUnits = 376 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 73.4, SellerName = @"Claudia Kobayashi", SellerCity = @"New York", Date = @"07/02/2008", Value = 48.6, NumberOfUnits = 40 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 43.6, SellerName = @"Larry Lieb", SellerCity = @"London", Date = @"07/10/2008", Value = 38, NumberOfUnits = 112 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 16.4, SellerName = @"Antonio Charbonneau", SellerCity = @"New York", Date = @"07/15/2008", Value = 9.8, NumberOfUnits = 224 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 71.4, SellerName = @"Stanley Brooker", SellerCity = @"Tokyo", Date = @"07/16/2008", Value = 66.4, NumberOfUnits = 145 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 94.6, SellerName = @"Stanley Brooker", SellerCity = @"Mellvile", Date = @"07/21/2008", Value = 46.6, NumberOfUnits = 272 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 50.8, SellerName = @"Claudia Kobayashi", SellerCity = @"London", Date = @"07/27/2008", Value = 90.2, NumberOfUnits = 278 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 12.8, SellerName = @"Harry Tyler", SellerCity = @"Seattle", Date = @"07/27/2008", Value = 89.2, NumberOfUnits = 253 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 35.8, SellerName = @"Nicholas Carmona", SellerCity = @"New York", Date = @"08/01/2008", Value = 28.4, NumberOfUnits = 255 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 17.2, SellerName = @"David Haley", SellerCity = @"Seattle", Date = @"08/02/2008", Value = 0.6, NumberOfUnits = 46 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 22.2, SellerName = @"Benjamin Dupree", SellerCity = @"Tokyo", Date = @"08/08/2008", Value = 58.6, NumberOfUnits = 279 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 63, SellerName = @"Russell Shorter", SellerCity = @"Sofia", Date = @"08/08/2008", Value = 91.8, NumberOfUnits = 89 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 83.8, SellerName = @"Larry Lieb", SellerCity = @"Sofia", Date = @"08/14/2008", Value = 52.6, NumberOfUnits = 17 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 14.2, SellerName = @"Lydia Burson", SellerCity = @"Sofia", Date = @"08/21/2008", Value = 54, NumberOfUnits = 470 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 34.6, SellerName = @"Elisa Longbottom", SellerCity = @"Mellvile", Date = @"08/25/2008", Value = 1.8, NumberOfUnits = 195 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 86.8, SellerName = @"Lydia Burson", SellerCity = @"New York", Date = @"08/27/2008", Value = 23.8, NumberOfUnits = 173 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 42.2, SellerName = @"Benjamin Dupree", SellerCity = @"New York", Date = @"09/01/2008", Value = 51.2, NumberOfUnits = 472 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 25.8, SellerName = @"Larry Lieb", SellerCity = @"Seattle", Date = @"09/06/2008", Value = 88.4, NumberOfUnits = 148 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 23.2, SellerName = @"Walter Pang", SellerCity = @"Mellvile", Date = @"09/06/2008", Value = 94.6, NumberOfUnits = 314 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 83.8, SellerName = @"Nicholas Carmona", SellerCity = @"Seattle", Date = @"09/07/2008", Value = 66.8, NumberOfUnits = 431 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 84.4, SellerName = @"Walter Pang", SellerCity = @"Mellvile", Date = @"09/07/2008", Value = 27.6, NumberOfUnits = 347 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 7.4, SellerName = @"Harry Tyler", SellerCity = @"Berlin", Date = @"09/11/2008", Value = 2.8, NumberOfUnits = 27 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 9.6, SellerName = @"Elisa Longbottom", SellerCity = @"Berlin", Date = @"09/12/2008", Value = 12, NumberOfUnits = 5 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 50.8, SellerName = @"Larry Lieb", SellerCity = @"Mellvile", Date = @"09/19/2008", Value = 16.6, NumberOfUnits = 191 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 80, SellerName = @"Bryan Culver", SellerCity = @"New York", Date = @"09/25/2008", Value = 84.4, NumberOfUnits = 421 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 62.2, SellerName = @"Carl Costello", SellerCity = @"Seattle", Date = @"10/03/2008", Value = 29, NumberOfUnits = 297 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 96.2, SellerName = @"Glenn Landeros", SellerCity = @"New York", Date = @"10/04/2008", Value = 15.8, NumberOfUnits = 128 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 47, SellerName = @"Howard Sprouse", SellerCity = @"Mellvile", Date = @"10/13/2008", Value = 37.4, NumberOfUnits = 210 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 35.8, SellerName = @"Russell Shorter", SellerCity = @"London", Date = @"10/14/2008", Value = 27, NumberOfUnits = 315 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 79, SellerName = @"Benjamin Meekins", SellerCity = @"New York", Date = @"10/19/2008", Value = 69.8, NumberOfUnits = 489 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 84.4, SellerName = @"Walter Pang", SellerCity = @"Mellvile", Date = @"10/21/2008", Value = 61.4, NumberOfUnits = 47 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 25.6, SellerName = @"John Smith", SellerCity = @"Mellvile", Date = @"10/22/2008", Value = 69.4, NumberOfUnits = 92 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 24, SellerName = @"Alfredo Fetuchini", SellerCity = @"Mellvile", Date = @"11/01/2008", Value = 81.2, NumberOfUnits = 30 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 53.6, SellerName = @"Stanley Brooker", SellerCity = @"Berlin", Date = @"11/01/2008", Value = 15, NumberOfUnits = 132 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 68.2, SellerName = @"Bryan Culver", SellerCity = @"London", Date = @"11/10/2008", Value = 6.2, NumberOfUnits = 368 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 60, SellerName = @"Kathe Pettel", SellerCity = @"New York", Date = @"11/11/2008", Value = 39.2, NumberOfUnits = 482 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 5.8, SellerName = @"Antonio Charbonneau", SellerCity = @"Mellvile", Date = @"11/11/2008", Value = 48.8, NumberOfUnits = 22 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 96, SellerName = @"Claudia Kobayashi", SellerCity = @"London", Date = @"11/20/2008", Value = 87.2, NumberOfUnits = 159 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 59.2, SellerName = @"Alfredo Fetuchini", SellerCity = @"Berlin", Date = @"11/25/2008", Value = 88.6, NumberOfUnits = 52 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 94, SellerName = @"Harry Tyler", SellerCity = @"Tokyo", Date = @"01/05/2009", Value = 79.8, NumberOfUnits = 194 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 12.8, SellerName = @"David Haley", SellerCity = @"Berlin", Date = @"01/08/2009", Value = 43, NumberOfUnits = 100 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 38, SellerName = @"Benjamin Meekins", SellerCity = @"Berlin", Date = @"01/10/2009", Value = 48.4, NumberOfUnits = 252 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 79.4, SellerName = @"Kathe Pettel", SellerCity = @"Tokyo", Date = @"01/13/2009", Value = 68.6, NumberOfUnits = 116 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 91, SellerName = @"Elisa Longbottom", SellerCity = @"London", Date = @"01/14/2009", Value = 27.6, NumberOfUnits = 259 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 100, SellerName = @"Glenn Landeros", SellerCity = @"London", Date = @"01/19/2009", Value = 56.8, NumberOfUnits = 217 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 43.4, SellerName = @"Bryan Culver", SellerCity = @"Seattle", Date = @"01/22/2009", Value = 36.6, NumberOfUnits = 48 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 0.8, SellerName = @"Stanley Brooker", SellerCity = @"New York", Date = @"02/02/2009", Value = 71.4, NumberOfUnits = 445 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 60.6, SellerName = @"Kathe Pettel", SellerCity = @"Mellvile", Date = @"02/03/2009", Value = 44.6, NumberOfUnits = 90 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 13.8, SellerName = @"Harry Tyler", SellerCity = @"Sofia", Date = @"02/07/2009", Value = 36.2, NumberOfUnits = 453 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 44.2, SellerName = @"Harry Tyler", SellerCity = @"Mellvile", Date = @"02/07/2009", Value = 85.6, NumberOfUnits = 450 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 94.4, SellerName = @"Lydia Burson", SellerCity = @"Sofia", Date = @"02/07/2009", Value = 48.2, NumberOfUnits = 152 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 8.8, SellerName = @"Harry Tyler", SellerCity = @"Berlin", Date = @"02/16/2009", Value = 46.6, NumberOfUnits = 119 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 79.2, SellerName = @"Kathe Pettel", SellerCity = @"Tokyo", Date = @"02/16/2009", Value = 29.2, NumberOfUnits = 463 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 18.6, SellerName = @"Howard Sprouse", SellerCity = @"Tokyo", Date = @"02/17/2009", Value = 19.8, NumberOfUnits = 150 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 28, SellerName = @"Walter Pang", SellerCity = @"Berlin", Date = @"02/19/2009", Value = 17.6, NumberOfUnits = 210 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 67.2, SellerName = @"Kathe Pettel", SellerCity = @"Tokyo", Date = @"02/20/2009", Value = 36.4, NumberOfUnits = 150 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 36, SellerName = @"Benjamin Meekins", SellerCity = @"London", Date = @"02/21/2009", Value = 74, NumberOfUnits = 97 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 34.2, SellerName = @"Stanley Brooker", SellerCity = @"Berlin", Date = @"02/22/2009", Value = 86.4, NumberOfUnits = 256 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 66.4, SellerName = @"Russell Shorter", SellerCity = @"London", Date = @"02/24/2009", Value = 53, NumberOfUnits = 172 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 15, SellerName = @"Monica Freitag", SellerCity = @"Mellvile", Date = @"02/24/2009", Value = 5.2, NumberOfUnits = 489 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 52, SellerName = @"Claudia Kobayashi", SellerCity = @"Sofia", Date = @"02/27/2009", Value = 9.2, NumberOfUnits = 222 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 98.4, SellerName = @"Nicholas Carmona", SellerCity = @"Berlin", Date = @"03/03/2009", Value = 81.4, NumberOfUnits = 300 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 72.8, SellerName = @"Harry Tyler", SellerCity = @"London", Date = @"03/03/2009", Value = 1.4, NumberOfUnits = 270 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 16.4, SellerName = @"Claudia Kobayashi", SellerCity = @"London", Date = @"03/07/2009", Value = 81.4, NumberOfUnits = 263 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 93.6, SellerName = @"Elisa Longbottom", SellerCity = @"Mellvile", Date = @"03/10/2009", Value = 22.8, NumberOfUnits = 28 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 42.2, SellerName = @"Howard Sprouse", SellerCity = @"London", Date = @"03/15/2009", Value = 20.4, NumberOfUnits = 237 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 55, SellerName = @"Claudia Kobayashi", SellerCity = @"Tokyo", Date = @"03/16/2009", Value = 64, NumberOfUnits = 171 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 97.4, SellerName = @"Kathe Pettel", SellerCity = @"New York", Date = @"03/27/2009", Value = 24, NumberOfUnits = 251 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 51, SellerName = @"Antonio Charbonneau", SellerCity = @"London", Date = @"04/01/2009", Value = 32.4, NumberOfUnits = 275 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 4.8, SellerName = @"Brandon Mckim", SellerCity = @"London", Date = @"04/06/2009", Value = 42, NumberOfUnits = 311 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 71, SellerName = @"Monica Freitag", SellerCity = @"New York", Date = @"04/07/2009", Value = 82.8, NumberOfUnits = 217 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 96.8, SellerName = @"Claudia Kobayashi", SellerCity = @"London", Date = @"04/09/2009", Value = 62.2, NumberOfUnits = 360 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 83.6, SellerName = @"Howard Sprouse", SellerCity = @"Berlin", Date = @"04/12/2009", Value = 51.6, NumberOfUnits = 35 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 96.4, SellerName = @"Nicholas Carmona", SellerCity = @"New York", Date = @"04/15/2009", Value = 81, NumberOfUnits = 294 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 70.8, SellerName = @"Howard Sprouse", SellerCity = @"Seattle", Date = @"04/16/2009", Value = 36, NumberOfUnits = 436 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 94.6, SellerName = @"Kathe Pettel", SellerCity = @"London", Date = @"04/20/2009", Value = 82.6, NumberOfUnits = 78 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 29.6, SellerName = @"David Haley", SellerCity = @"Tokyo", Date = @"04/22/2009", Value = 94, NumberOfUnits = 301 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 70.6, SellerName = @"Mark Slater", SellerCity = @"New York", Date = @"05/02/2009", Value = 92.6, NumberOfUnits = 24 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 71.8, SellerName = @"Howard Sprouse", SellerCity = @"Seattle", Date = @"05/04/2009", Value = 19.4, NumberOfUnits = 332 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 14.6, SellerName = @"Mark Slater", SellerCity = @"Berlin", Date = @"05/11/2009", Value = 56.4, NumberOfUnits = 307 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 36.8, SellerName = @"Harold Garvin", SellerCity = @"Seattle", Date = @"05/11/2009", Value = 34.4, NumberOfUnits = 375 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 62.8, SellerName = @"Benjamin Dupree", SellerCity = @"Mellvile", Date = @"05/12/2009", Value = 2, NumberOfUnits = 499 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 13.8, SellerName = @"Russell Shorter", SellerCity = @"London", Date = @"05/21/2009", Value = 42.6, NumberOfUnits = 337 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 46.2, SellerName = @"Larry Lieb", SellerCity = @"London", Date = @"05/24/2009", Value = 55.4, NumberOfUnits = 284 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 95.4, SellerName = @"Howard Sprouse", SellerCity = @"Berlin", Date = @"05/26/2009", Value = 94.8, NumberOfUnits = 292 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 78.2, SellerName = @"Howard Sprouse", SellerCity = @"Sofia", Date = @"05/26/2009", Value = 60.2, NumberOfUnits = 424 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 99.4, SellerName = @"Mark Slater", SellerCity = @"Mellvile", Date = @"06/05/2009", Value = 29, NumberOfUnits = 271 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 87, SellerName = @"Howard Sprouse", SellerCity = @"Mellvile", Date = @"06/10/2009", Value = 94, NumberOfUnits = 6 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 13.6, SellerName = @"Elisa Longbottom", SellerCity = @"Sofia", Date = @"06/12/2009", Value = 95, NumberOfUnits = 44 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 99.8, SellerName = @"Nicholas Carmona", SellerCity = @"Seattle", Date = @"06/12/2009", Value = 74.2, NumberOfUnits = 277 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 17, SellerName = @"Brandon Mckim", SellerCity = @"Seattle", Date = @"06/13/2009", Value = 65.2, NumberOfUnits = 98 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 42.4, SellerName = @"Elisa Longbottom", SellerCity = @"Mellvile", Date = @"06/22/2009", Value = 68.6, NumberOfUnits = 443 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 79.6, SellerName = @"Benjamin Dupree", SellerCity = @"Seattle", Date = @"06/26/2009", Value = 81.4, NumberOfUnits = 409 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 26.4, SellerName = @"Walter Pang", SellerCity = @"New York", Date = @"07/02/2009", Value = 68.2, NumberOfUnits = 240 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 34.2, SellerName = @"Kathe Pettel", SellerCity = @"Seattle", Date = @"07/10/2009", Value = 95.6, NumberOfUnits = 23 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 29.4, SellerName = @"Larry Lieb", SellerCity = @"Mellvile", Date = @"07/12/2009", Value = 36, NumberOfUnits = 109 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 86.8, SellerName = @"Nicholas Carmona", SellerCity = @"Berlin", Date = @"07/13/2009", Value = 30, NumberOfUnits = 117 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 58.4, SellerName = @"Mark Slater", SellerCity = @"New York", Date = @"07/15/2009", Value = 34.4, NumberOfUnits = 336 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 39.8, SellerName = @"Antonio Charbonneau", SellerCity = @"Seattle", Date = @"07/18/2009", Value = 92.4, NumberOfUnits = 372 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 10.2, SellerName = @"Larry Lieb", SellerCity = @"Berlin", Date = @"07/19/2009", Value = 90.4, NumberOfUnits = 403 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 17.8, SellerName = @"Harry Tyler", SellerCity = @"Seattle", Date = @"07/19/2009", Value = 66.2, NumberOfUnits = 144 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 21.6, SellerName = @"Lydia Burson", SellerCity = @"Seattle", Date = @"07/19/2009", Value = 41.8, NumberOfUnits = 395 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 33.6, SellerName = @"Nicholas Carmona", SellerCity = @"New York", Date = @"07/20/2009", Value = 16.6, NumberOfUnits = 236 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 48.8, SellerName = @"Larry Lieb", SellerCity = @"Seattle", Date = @"07/20/2009", Value = 86.8, NumberOfUnits = 160 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 81.8, SellerName = @"David Haley", SellerCity = @"Sofia", Date = @"07/20/2009", Value = 65.8, NumberOfUnits = 157 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 9.8, SellerName = @"Glenn Landeros", SellerCity = @"Sofia", Date = @"07/25/2009", Value = 0.2, NumberOfUnits = 255 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 88.6, SellerName = @"Mark Slater", SellerCity = @"London", Date = @"08/16/2009", Value = 43, NumberOfUnits = 284 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 89.4, SellerName = @"Walter Pang", SellerCity = @"Tokyo", Date = @"08/17/2009", Value = 15.8, NumberOfUnits = 333 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 24, SellerName = @"Monica Freitag", SellerCity = @"Seattle", Date = @"08/17/2009", Value = 51.6, NumberOfUnits = 48 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 19.4, SellerName = @"Kathe Pettel", SellerCity = @"New York", Date = @"08/18/2009", Value = 82.6, NumberOfUnits = 399 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 9.4, SellerName = @"Mark Slater", SellerCity = @"Berlin", Date = @"08/24/2009", Value = 68.6, NumberOfUnits = 413 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 1.2, SellerName = @"Monica Freitag", SellerCity = @"Sofia", Date = @"09/06/2009", Value = 72, NumberOfUnits = 182 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 77, SellerName = @"Russell Shorter", SellerCity = @"Mellvile", Date = @"09/06/2009", Value = 45, NumberOfUnits = 156 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 80.8, SellerName = @"Antonio Charbonneau", SellerCity = @"Mellvile", Date = @"09/09/2009", Value = 92.4, NumberOfUnits = 293 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 22.8, SellerName = @"Benjamin Dupree", SellerCity = @"Berlin", Date = @"10/01/2009", Value = 100, NumberOfUnits = 16 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 78.2, SellerName = @"Benjamin Meekins", SellerCity = @"Seattle", Date = @"10/01/2009", Value = 16, NumberOfUnits = 106 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 73, SellerName = @"Glenn Landeros", SellerCity = @"Tokyo", Date = @"10/06/2009", Value = 91.6, NumberOfUnits = 16 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 22.2, SellerName = @"John Smith", SellerCity = @"Tokyo", Date = @"10/07/2009", Value = 1.8, NumberOfUnits = 187 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 42.8, SellerName = @"Harry Tyler", SellerCity = @"Seattle", Date = @"10/10/2009", Value = 21.8, NumberOfUnits = 137 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 46.2, SellerName = @"Mark Slater", SellerCity = @"Seattle", Date = @"10/14/2009", Value = 15, NumberOfUnits = 138 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 14.4, SellerName = @"Mark Slater", SellerCity = @"Seattle", Date = @"10/24/2009", Value = 65, NumberOfUnits = 256 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 40.2, SellerName = @"Antonio Charbonneau", SellerCity = @"London", Date = @"10/24/2009", Value = 11.2, NumberOfUnits = 353 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 17.2, SellerName = @"Lydia Burson", SellerCity = @"Tokyo", Date = @"11/01/2009", Value = 95, NumberOfUnits = 359 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 52, SellerName = @"Walter Pang", SellerCity = @"Tokyo", Date = @"11/04/2009", Value = 43.2, NumberOfUnits = 134 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 91, SellerName = @"Larry Lieb", SellerCity = @"Seattle", Date = @"11/09/2009", Value = 25.2, NumberOfUnits = 263 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 88.6, SellerName = @"Monica Freitag", SellerCity = @"Seattle", Date = @"11/11/2009", Value = 41, NumberOfUnits = 313 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 46.6, SellerName = @"Stanley Brooker", SellerCity = @"Mellvile", Date = @"11/16/2009", Value = 20.4, NumberOfUnits = 115 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 20.4, SellerName = @"Claudia Kobayashi", SellerCity = @"Berlin", Date = @"11/17/2009", Value = 33, NumberOfUnits = 414 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 70.8, SellerName = @"Kathe Pettel", SellerCity = @"New York", Date = @"11/21/2009", Value = 3, NumberOfUnits = 53 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 81.6, SellerName = @"John Smith", SellerCity = @"New York", Date = @"11/22/2009", Value = 86.8, NumberOfUnits = 472 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 9.8, SellerName = @"Harry Tyler", SellerCity = @"Mellvile", Date = @"11/23/2009", Value = 53.6, NumberOfUnits = 199 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 29.8, SellerName = @"Harold Garvin", SellerCity = @"Sofia", Date = @"11/24/2009", Value = 27.4, NumberOfUnits = 241 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 33.2, SellerName = @"Glenn Landeros", SellerCity = @"New York", Date = @"11/24/2009", Value = 1.2, NumberOfUnits = 320 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 65.6, SellerName = @"David Haley", SellerCity = @"London", Date = @"01/02/2010", Value = 20.6, NumberOfUnits = 299 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 62.2, SellerName = @"Benjamin Dupree", SellerCity = @"London", Date = @"01/08/2010", Value = 35.4, NumberOfUnits = 366 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 78.6, SellerName = @"John Smith", SellerCity = @"New York", Date = @"01/10/2010", Value = 27.8, NumberOfUnits = 290 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 11.6, SellerName = @"Lydia Burson", SellerCity = @"Sofia", Date = @"01/11/2010", Value = 61.8, NumberOfUnits = 350 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 33.4, SellerName = @"Russell Shorter", SellerCity = @"Sofia", Date = @"01/14/2010", Value = 33.8, NumberOfUnits = 469 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 96.2, SellerName = @"Nicholas Carmona", SellerCity = @"Sofia", Date = @"01/21/2010", Value = 75.6, NumberOfUnits = 352 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 92.2, SellerName = @"Larry Lieb", SellerCity = @"Seattle", Date = @"01/25/2010", Value = 38.8, NumberOfUnits = 47 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 93.2, SellerName = @"Russell Shorter", SellerCity = @"Tokyo", Date = @"02/02/2010", Value = 66.4, NumberOfUnits = 153 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 39, SellerName = @"Antonio Charbonneau", SellerCity = @"Berlin", Date = @"02/02/2010", Value = 28.6, NumberOfUnits = 211 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 99.4, SellerName = @"Russell Shorter", SellerCity = @"Sofia", Date = @"02/04/2010", Value = 67, NumberOfUnits = 267 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 94.4, SellerName = @"Antonio Charbonneau", SellerCity = @"New York", Date = @"02/04/2010", Value = 71.4, NumberOfUnits = 91 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 19.8, SellerName = @"Claudia Kobayashi", SellerCity = @"Tokyo", Date = @"02/05/2010", Value = 46, NumberOfUnits = 84 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 87.2, SellerName = @"Howard Sprouse", SellerCity = @"Mellvile", Date = @"02/11/2010", Value = 66.8, NumberOfUnits = 270 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 76.2, SellerName = @"Alfredo Fetuchini", SellerCity = @"Berlin", Date = @"02/12/2010", Value = 87, NumberOfUnits = 496 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 52, SellerName = @"John Smith", SellerCity = @"Seattle", Date = @"02/16/2010", Value = 47.4, NumberOfUnits = 24 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 21.8, SellerName = @"Walter Pang", SellerCity = @"Mellvile", Date = @"02/17/2010", Value = 72.8, NumberOfUnits = 41 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 15.8, SellerName = @"John Smith", SellerCity = @"Mellvile", Date = @"02/22/2010", Value = 65.6, NumberOfUnits = 365 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 2.8, SellerName = @"Brandon Mckim", SellerCity = @"Sofia", Date = @"03/01/2010", Value = 68.6, NumberOfUnits = 202 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 52.4, SellerName = @"Howard Sprouse", SellerCity = @"Seattle", Date = @"03/01/2010", Value = 79.4, NumberOfUnits = 225 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 0.4, SellerName = @"Stanley Brooker", SellerCity = @"Mellvile", Date = @"03/03/2010", Value = 70.2, NumberOfUnits = 206 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 22.4, SellerName = @"Larry Lieb", SellerCity = @"Sofia", Date = @"03/11/2010", Value = 54.8, NumberOfUnits = 158 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 94.8, SellerName = @"Benjamin Meekins", SellerCity = @"London", Date = @"03/14/2010", Value = 70.4, NumberOfUnits = 169 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 1.2, SellerName = @"John Smith", SellerCity = @"New York", Date = @"03/15/2010", Value = 19, NumberOfUnits = 4 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 12.2, SellerName = @"Monica Freitag", SellerCity = @"New York", Date = @"03/15/2010", Value = 12.8, NumberOfUnits = 232 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 58.8, SellerName = @"Mark Slater", SellerCity = @"Berlin", Date = @"03/16/2010", Value = 78.8, NumberOfUnits = 421 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 44, SellerName = @"David Haley", SellerCity = @"Seattle", Date = @"03/25/2010", Value = 89.6, NumberOfUnits = 260 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 54.6, SellerName = @"Brandon Mckim", SellerCity = @"Seattle", Date = @"04/02/2010", Value = 92, NumberOfUnits = 194 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 94.6, SellerName = @"Walter Pang", SellerCity = @"Tokyo", Date = @"04/05/2010", Value = 35.4, NumberOfUnits = 491 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 11.2, SellerName = @"Harold Garvin", SellerCity = @"London", Date = @"04/14/2010", Value = 30, NumberOfUnits = 256 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 18.2, SellerName = @"Alfredo Fetuchini", SellerCity = @"Mellvile", Date = @"04/15/2010", Value = 84.6, NumberOfUnits = 279 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 8.4, SellerName = @"Carl Costello", SellerCity = @"Berlin", Date = @"04/15/2010", Value = 99.6, NumberOfUnits = 287 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 78, SellerName = @"Carl Costello", SellerCity = @"New York", Date = @"04/22/2010", Value = 59, NumberOfUnits = 363 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 55.6, SellerName = @"Mark Slater", SellerCity = @"Berlin", Date = @"04/22/2010", Value = 16.4, NumberOfUnits = 499 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 39.4, SellerName = @"Lydia Burson", SellerCity = @"Berlin", Date = @"04/24/2010", Value = 0.2, NumberOfUnits = 109 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 7.8, SellerName = @"Benjamin Dupree", SellerCity = @"Berlin", Date = @"05/04/2010", Value = 99.6, NumberOfUnits = 25 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 62.4, SellerName = @"Alfredo Fetuchini", SellerCity = @"Mellvile", Date = @"05/05/2010", Value = 48, NumberOfUnits = 64 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 38.8, SellerName = @"Howard Sprouse", SellerCity = @"London", Date = @"05/06/2010", Value = 57.8, NumberOfUnits = 256 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 17.8, SellerName = @"Benjamin Meekins", SellerCity = @"Mellvile", Date = @"05/07/2010", Value = 15.4, NumberOfUnits = 50 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 57.8, SellerName = @"Bryan Culver", SellerCity = @"Berlin", Date = @"05/07/2010", Value = 58.6, NumberOfUnits = 437 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 21.4, SellerName = @"Bryan Culver", SellerCity = @"Sofia", Date = @"05/19/2010", Value = 41, NumberOfUnits = 253 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 10.2, SellerName = @"Monica Freitag", SellerCity = @"London", Date = @"05/22/2010", Value = 24, NumberOfUnits = 312 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 87.8, SellerName = @"Claudia Kobayashi", SellerCity = @"London", Date = @"05/24/2010", Value = 12.6, NumberOfUnits = 82 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 42.6, SellerName = @"Harold Garvin", SellerCity = @"New York", Date = @"06/01/2010", Value = 32.2, NumberOfUnits = 467 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 79.8, SellerName = @"Alfredo Fetuchini", SellerCity = @"Sofia", Date = @"06/05/2010", Value = 69.6, NumberOfUnits = 74 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 1.8, SellerName = @"Nicholas Carmona", SellerCity = @"Seattle", Date = @"06/10/2010", Value = 14.8, NumberOfUnits = 81 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 15, SellerName = @"Kathe Pettel", SellerCity = @"Berlin", Date = @"06/25/2010", Value = 18.8, NumberOfUnits = 88 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 43.4, SellerName = @"Antonio Charbonneau", SellerCity = @"Mellvile", Date = @"06/26/2010", Value = 44.4, NumberOfUnits = 126 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 16.2, SellerName = @"Elisa Longbottom", SellerCity = @"Sofia", Date = @"06/27/2010", Value = 77.8, NumberOfUnits = 112 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 59.2, SellerName = @"Antonio Charbonneau", SellerCity = @"Sofia", Date = @"06/27/2010", Value = 15.4, NumberOfUnits = 47 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 40, SellerName = @"Claudia Kobayashi", SellerCity = @"Sofia", Date = @"07/05/2010", Value = 29.4, NumberOfUnits = 218 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 27, SellerName = @"Nicholas Carmona", SellerCity = @"New York", Date = @"07/05/2010", Value = 30, NumberOfUnits = 34 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 14.4, SellerName = @"Bryan Culver", SellerCity = @"Sofia", Date = @"07/13/2010", Value = 83.4, NumberOfUnits = 492 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 53.4, SellerName = @"Harry Tyler", SellerCity = @"Sofia", Date = @"07/16/2010", Value = 41.6, NumberOfUnits = 464 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 21.4, SellerName = @"Harry Tyler", SellerCity = @"Seattle", Date = @"07/17/2010", Value = 83.4, NumberOfUnits = 118 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 24, SellerName = @"Nicholas Carmona", SellerCity = @"Seattle", Date = @"07/18/2010", Value = 94.2, NumberOfUnits = 442 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 37.6, SellerName = @"Benjamin Meekins", SellerCity = @"London", Date = @"07/23/2010", Value = 59.6, NumberOfUnits = 248 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 60.8, SellerName = @"Lydia Burson", SellerCity = @"London", Date = @"07/23/2010", Value = 83.6, NumberOfUnits = 472 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 78, SellerName = @"Alfredo Fetuchini", SellerCity = @"New York", Date = @"07/24/2010", Value = 84, NumberOfUnits = 140 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 47.6, SellerName = @"Lydia Burson", SellerCity = @"Tokyo", Date = @"07/26/2010", Value = 86.6, NumberOfUnits = 118 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 58.2, SellerName = @"Harry Tyler", SellerCity = @"Sofia", Date = @"07/27/2010", Value = 64, NumberOfUnits = 176 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 98.4, SellerName = @"Russell Shorter", SellerCity = @"Mellvile", Date = @"08/01/2010", Value = 23.4, NumberOfUnits = 77 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 3, SellerName = @"Glenn Landeros", SellerCity = @"Sofia", Date = @"08/08/2010", Value = 74.4, NumberOfUnits = 105 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 98.2, SellerName = @"Alfredo Fetuchini", SellerCity = @"Tokyo", Date = @"08/21/2010", Value = 60.8, NumberOfUnits = 160 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 79, SellerName = @"Stanley Brooker", SellerCity = @"Seattle", Date = @"08/26/2010", Value = 67, NumberOfUnits = 186 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 17.8, SellerName = @"Harold Garvin", SellerCity = @"Seattle", Date = @"09/04/2010", Value = 29, NumberOfUnits = 380 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 38.8, SellerName = @"John Smith", SellerCity = @"Tokyo", Date = @"09/11/2010", Value = 41.6, NumberOfUnits = 470 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 75.2, SellerName = @"Benjamin Dupree", SellerCity = @"Mellvile", Date = @"09/13/2010", Value = 42.8, NumberOfUnits = 348 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 55.4, SellerName = @"Carl Costello", SellerCity = @"London", Date = @"09/14/2010", Value = 29.4, NumberOfUnits = 151 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 51.4, SellerName = @"Kathe Pettel", SellerCity = @"New York", Date = @"09/24/2010", Value = 86.6, NumberOfUnits = 7 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 31.4, SellerName = @"Monica Freitag", SellerCity = @"New York", Date = @"10/07/2010", Value = 39, NumberOfUnits = 123 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 80, SellerName = @"Mark Slater", SellerCity = @"Seattle", Date = @"10/08/2010", Value = 8.8, NumberOfUnits = 374 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 94.8, SellerName = @"Kathe Pettel", SellerCity = @"Mellvile", Date = @"10/11/2010", Value = 96.8, NumberOfUnits = 178 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 42, SellerName = @"Bryan Culver", SellerCity = @"Sofia", Date = @"10/22/2010", Value = 31.4, NumberOfUnits = 354 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 46.6, SellerName = @"Elisa Longbottom", SellerCity = @"New York", Date = @"10/25/2010", Value = 85.6, NumberOfUnits = 459 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 27.2, SellerName = @"Mark Slater", SellerCity = @"London", Date = @"11/02/2010", Value = 46.4, NumberOfUnits = 78 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 30.2, SellerName = @"Walter Pang", SellerCity = @"Berlin", Date = @"11/03/2010", Value = 52.2, NumberOfUnits = 417 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 82.2, SellerName = @"Walter Pang", SellerCity = @"Seattle", Date = @"11/12/2010", Value = 15.4, NumberOfUnits = 208 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 13.2, SellerName = @"Harold Garvin", SellerCity = @"Seattle", Date = @"11/19/2010", Value = 48.6, NumberOfUnits = 359 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 8.8, SellerName = @"Russell Shorter", SellerCity = @"New York", Date = @"11/25/2010", Value = 24.6, NumberOfUnits = 392 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 78.4, SellerName = @"John Smith", SellerCity = @"London", Date = @"01/01/2011", Value = 37.6, NumberOfUnits = 241 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 50.6, SellerName = @"Claudia Kobayashi", SellerCity = @"Seattle", Date = @"01/04/2011", Value = 27.2, NumberOfUnits = 62 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 6.4, SellerName = @"Elisa Longbottom", SellerCity = @"Tokyo", Date = @"01/06/2011", Value = 89.6, NumberOfUnits = 485 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 47.4, SellerName = @"Bryan Culver", SellerCity = @"Sofia", Date = @"01/14/2011", Value = 5, NumberOfUnits = 470 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 6.2, SellerName = @"Harry Tyler", SellerCity = @"Seattle", Date = @"01/23/2011", Value = 78.6, NumberOfUnits = 197 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 57.6, SellerName = @"Larry Lieb", SellerCity = @"Berlin", Date = @"01/26/2011", Value = 59.8, NumberOfUnits = 353 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 37.6, SellerName = @"Benjamin Meekins", SellerCity = @"Mellvile", Date = @"02/01/2011", Value = 39.6, NumberOfUnits = 338 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 21, SellerName = @"Claudia Kobayashi", SellerCity = @"New York", Date = @"02/08/2011", Value = 93, NumberOfUnits = 17 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 11.8, SellerName = @"Antonio Charbonneau", SellerCity = @"Berlin", Date = @"02/12/2011", Value = 61.4, NumberOfUnits = 429 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 65, SellerName = @"Alfredo Fetuchini", SellerCity = @"Tokyo", Date = @"02/14/2011", Value = 24.4, NumberOfUnits = 385 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 20, SellerName = @"Claudia Kobayashi", SellerCity = @"New York", Date = @"02/20/2011", Value = 35.4, NumberOfUnits = 166 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 3.2, SellerName = @"Lydia Burson", SellerCity = @"Seattle", Date = @"02/20/2011", Value = 52.6, NumberOfUnits = 137 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 18.2, SellerName = @"Russell Shorter", SellerCity = @"New York", Date = @"02/24/2011", Value = 8.2, NumberOfUnits = 443 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 20.4, SellerName = @"Carl Costello", SellerCity = @"Seattle", Date = @"02/26/2011", Value = 87.4, NumberOfUnits = 40 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 20.6, SellerName = @"Glenn Landeros", SellerCity = @"London", Date = @"03/05/2011", Value = 7.4, NumberOfUnits = 138 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 23.8, SellerName = @"Lydia Burson", SellerCity = @"Tokyo", Date = @"03/09/2011", Value = 18.2, NumberOfUnits = 15 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 76.4, SellerName = @"Antonio Charbonneau", SellerCity = @"Mellvile", Date = @"03/09/2011", Value = 74.6, NumberOfUnits = 469 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 93.4, SellerName = @"Russell Shorter", SellerCity = @"London", Date = @"03/11/2011", Value = 89, NumberOfUnits = 426 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 63, SellerName = @"Benjamin Dupree", SellerCity = @"Seattle", Date = @"03/16/2011", Value = 32.6, NumberOfUnits = 208 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 58.6, SellerName = @"Brandon Mckim", SellerCity = @"Seattle", Date = @"03/21/2011", Value = 51, NumberOfUnits = 155 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 82.4, SellerName = @"Stanley Brooker", SellerCity = @"Seattle", Date = @"03/23/2011", Value = 33.4, NumberOfUnits = 381 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 19.2, SellerName = @"Nicholas Carmona", SellerCity = @"Tokyo", Date = @"04/12/2011", Value = 75.2, NumberOfUnits = 5 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 53.6, SellerName = @"Walter Pang", SellerCity = @"London", Date = @"04/12/2011", Value = 14.6, NumberOfUnits = 221 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 97.4, SellerName = @"Howard Sprouse", SellerCity = @"Sofia", Date = @"04/14/2011", Value = 84.8, NumberOfUnits = 39 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 74.2, SellerName = @"Mark Slater", SellerCity = @"New York", Date = @"04/16/2011", Value = 51.4, NumberOfUnits = 468 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 8.2, SellerName = @"Claudia Kobayashi", SellerCity = @"Seattle", Date = @"04/17/2011", Value = 0.8, NumberOfUnits = 44 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 59.2, SellerName = @"John Smith", SellerCity = @"Mellvile", Date = @"04/22/2011", Value = 47.6, NumberOfUnits = 287 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 96.8, SellerName = @"Russell Shorter", SellerCity = @"Sofia", Date = @"04/24/2011", Value = 78.6, NumberOfUnits = 463 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 76.8, SellerName = @"Walter Pang", SellerCity = @"Seattle", Date = @"04/24/2011", Value = 63, NumberOfUnits = 335 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 73.4, SellerName = @"Walter Pang", SellerCity = @"Berlin", Date = @"04/24/2011", Value = 30.6, NumberOfUnits = 211 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 66.4, SellerName = @"Benjamin Dupree", SellerCity = @"Seattle", Date = @"05/03/2011", Value = 87.4, NumberOfUnits = 291 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 37, SellerName = @"John Smith", SellerCity = @"Sofia", Date = @"05/05/2011", Value = 40.2, NumberOfUnits = 1 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 21.4, SellerName = @"Alfredo Fetuchini", SellerCity = @"Seattle", Date = @"05/06/2011", Value = 46, NumberOfUnits = 120 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 20, SellerName = @"Benjamin Dupree", SellerCity = @"Berlin", Date = @"05/06/2011", Value = 72.6, NumberOfUnits = 382 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 16.6, SellerName = @"Harry Tyler", SellerCity = @"Seattle", Date = @"05/07/2011", Value = 7.8, NumberOfUnits = 63 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 41.8, SellerName = @"Stanley Brooker", SellerCity = @"Seattle", Date = @"05/12/2011", Value = 94.4, NumberOfUnits = 230 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 5, SellerName = @"Larry Lieb", SellerCity = @"Tokyo", Date = @"05/13/2011", Value = 31, NumberOfUnits = 362 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 10.8, SellerName = @"Monica Freitag", SellerCity = @"New York", Date = @"05/17/2011", Value = 59.8, NumberOfUnits = 430 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 66.2, SellerName = @"Nicholas Carmona", SellerCity = @"Seattle", Date = @"05/23/2011", Value = 91.2, NumberOfUnits = 204 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 61, SellerName = @"Antonio Charbonneau", SellerCity = @"Berlin", Date = @"05/24/2011", Value = 86.2, NumberOfUnits = 118 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 68.8, SellerName = @"Walter Pang", SellerCity = @"Sofia", Date = @"06/01/2011", Value = 14.6, NumberOfUnits = 17 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 40.8, SellerName = @"Walter Pang", SellerCity = @"New York", Date = @"06/03/2011", Value = 9, NumberOfUnits = 312 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 97, SellerName = @"Lydia Burson", SellerCity = @"Seattle", Date = @"06/12/2011", Value = 95, NumberOfUnits = 283 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 67, SellerName = @"Benjamin Dupree", SellerCity = @"Seattle", Date = @"06/13/2011", Value = 27.6, NumberOfUnits = 460 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 67.2, SellerName = @"Howard Sprouse", SellerCity = @"New York", Date = @"06/14/2011", Value = 66.2, NumberOfUnits = 295 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 28.2, SellerName = @"Alfredo Fetuchini", SellerCity = @"Mellvile", Date = @"06/15/2011", Value = 50.6, NumberOfUnits = 49 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 7.4, SellerName = @"Russell Shorter", SellerCity = @"Tokyo", Date = @"06/24/2011", Value = 8, NumberOfUnits = 127 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 39.2, SellerName = @"Mark Slater", SellerCity = @"Seattle", Date = @"06/27/2011", Value = 98.8, NumberOfUnits = 244 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 53.4, SellerName = @"Harold Garvin", SellerCity = @"Tokyo", Date = @"07/01/2011", Value = 11.2, NumberOfUnits = 188 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 25.6, SellerName = @"Benjamin Dupree", SellerCity = @"Seattle", Date = @"07/06/2011", Value = 56.2, NumberOfUnits = 458 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 70.4, SellerName = @"Nicholas Carmona", SellerCity = @"Mellvile", Date = @"07/08/2011", Value = 82.4, NumberOfUnits = 448 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 7.6, SellerName = @"Harold Garvin", SellerCity = @"Berlin", Date = @"07/27/2011", Value = 30.6, NumberOfUnits = 226 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 21.6, SellerName = @"Benjamin Dupree", SellerCity = @"London", Date = @"08/01/2011", Value = 69.6, NumberOfUnits = 474 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 37.6, SellerName = @"David Haley", SellerCity = @"Sofia", Date = @"08/02/2011", Value = 62.8, NumberOfUnits = 338 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 99.4, SellerName = @"Benjamin Meekins", SellerCity = @"London", Date = @"08/02/2011", Value = 75.2, NumberOfUnits = 88 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 72.2, SellerName = @"Carl Costello", SellerCity = @"Berlin", Date = @"08/04/2011", Value = 86.4, NumberOfUnits = 436 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 34.4, SellerName = @"Nicholas Carmona", SellerCity = @"Mellvile", Date = @"08/06/2011", Value = 9.2, NumberOfUnits = 297 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 47, SellerName = @"Russell Shorter", SellerCity = @"London", Date = @"08/07/2011", Value = 5.2, NumberOfUnits = 240 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 26.4, SellerName = @"Stanley Brooker", SellerCity = @"Sofia", Date = @"08/07/2011", Value = 80.2, NumberOfUnits = 415 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 49.2, SellerName = @"David Haley", SellerCity = @"Mellvile", Date = @"08/08/2011", Value = 61.2, NumberOfUnits = 435 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 95.2, SellerName = @"Monica Freitag", SellerCity = @"Berlin", Date = @"08/16/2011", Value = 73.8, NumberOfUnits = 64 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 74.2, SellerName = @"John Smith", SellerCity = @"Seattle", Date = @"08/23/2011", Value = 40.8, NumberOfUnits = 21 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 82.6, SellerName = @"Benjamin Dupree", SellerCity = @"London", Date = @"08/25/2011", Value = 55, NumberOfUnits = 467 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 42.8, SellerName = @"Lydia Burson", SellerCity = @"Sofia", Date = @"09/02/2011", Value = 28.2, NumberOfUnits = 98 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 83.6, SellerName = @"Russell Shorter", SellerCity = @"Mellvile", Date = @"09/04/2011", Value = 72.6, NumberOfUnits = 370 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 41.6, SellerName = @"Walter Pang", SellerCity = @"Berlin", Date = @"09/05/2011", Value = 81, NumberOfUnits = 94 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 74.2, SellerName = @"Benjamin Dupree", SellerCity = @"London", Date = @"09/09/2011", Value = 95, NumberOfUnits = 106 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 75.4, SellerName = @"Claudia Kobayashi", SellerCity = @"Sofia", Date = @"09/11/2011", Value = 10, NumberOfUnits = 261 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 10.2, SellerName = @"Howard Sprouse", SellerCity = @"Seattle", Date = @"09/17/2011", Value = 29.4, NumberOfUnits = 307 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 73, SellerName = @"Harry Tyler", SellerCity = @"New York", Date = @"09/17/2011", Value = 57, NumberOfUnits = 362 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 85.2, SellerName = @"Benjamin Meekins", SellerCity = @"Tokyo", Date = @"09/24/2011", Value = 24, NumberOfUnits = 330 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 77.6, SellerName = @"Walter Pang", SellerCity = @"New York", Date = @"09/26/2011", Value = 91.8, NumberOfUnits = 23 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 50.4, SellerName = @"David Haley", SellerCity = @"Berlin", Date = @"09/27/2011", Value = 66.8, NumberOfUnits = 392 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 32.4, SellerName = @"Larry Lieb", SellerCity = @"Seattle", Date = @"10/13/2011", Value = 81.6, NumberOfUnits = 16 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 63, SellerName = @"Lydia Burson", SellerCity = @"New York", Date = @"10/13/2011", Value = 31, NumberOfUnits = 100 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 13.4, SellerName = @"Carl Costello", SellerCity = @"Berlin", Date = @"10/22/2011", Value = 85.6, NumberOfUnits = 132 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 0.4, SellerName = @"Nicholas Carmona", SellerCity = @"Seattle", Date = @"10/22/2011", Value = 74.4, NumberOfUnits = 22 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 66.2, SellerName = @"Walter Pang", SellerCity = @"New York", Date = @"11/02/2011", Value = 88.2, NumberOfUnits = 96 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 50.2, SellerName = @"Elisa Longbottom", SellerCity = @"Berlin", Date = @"11/03/2011", Value = 31.4, NumberOfUnits = 76 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 68, SellerName = @"Stanley Brooker", SellerCity = @"Mellvile", Date = @"11/04/2011", Value = 91.2, NumberOfUnits = 492 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 6.6, SellerName = @"Harry Tyler", SellerCity = @"Berlin", Date = @"11/08/2011", Value = 51.6, NumberOfUnits = 49 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 35.6, SellerName = @"Russell Shorter", SellerCity = @"Mellvile", Date = @"11/12/2011", Value = 21, NumberOfUnits = 197 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 60, SellerName = @"Howard Sprouse", SellerCity = @"Tokyo", Date = @"11/12/2011", Value = 70.4, NumberOfUnits = 484 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 67.4, SellerName = @"Russell Shorter", SellerCity = @"Tokyo", Date = @"11/13/2011", Value = 14.4, NumberOfUnits = 182 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 52, SellerName = @"Alfredo Fetuchini", SellerCity = @"London", Date = @"11/15/2011", Value = 18.4, NumberOfUnits = 42 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 66.8, SellerName = @"Brandon Mckim", SellerCity = @"New York", Date = @"11/19/2011", Value = 52.8, NumberOfUnits = 109 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 56.2, SellerName = @"Harold Garvin", SellerCity = @"Mellvile", Date = @"11/23/2011", Value = 40.2, NumberOfUnits = 310 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 93.6, SellerName = @"Monica Freitag", SellerCity = @"Sofia", Date = @"01/03/2012", Value = 53.4, NumberOfUnits = 306 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 9.6, SellerName = @"Harold Garvin", SellerCity = @"Seattle", Date = @"01/06/2012", Value = 83, NumberOfUnits = 290 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 41.2, SellerName = @"Monica Freitag", SellerCity = @"Tokyo", Date = @"01/10/2012", Value = 29.8, NumberOfUnits = 499 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 9.8, SellerName = @"Kathe Pettel", SellerCity = @"Berlin", Date = @"01/11/2012", Value = 10.8, NumberOfUnits = 7 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 64.6, SellerName = @"Nicholas Carmona", SellerCity = @"Sofia", Date = @"01/14/2012", Value = 35, NumberOfUnits = 220 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 47.4, SellerName = @"Elisa Longbottom", SellerCity = @"New York", Date = @"01/15/2012", Value = 50.2, NumberOfUnits = 395 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 14.6, SellerName = @"Lydia Burson", SellerCity = @"Sofia", Date = @"01/18/2012", Value = 100, NumberOfUnits = 219 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 10.8, SellerName = @"Larry Lieb", SellerCity = @"Mellvile", Date = @"01/18/2012", Value = 92, NumberOfUnits = 229 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 65, SellerName = @"Nicholas Carmona", SellerCity = @"Mellvile", Date = @"01/22/2012", Value = 55.8, NumberOfUnits = 111 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 48, SellerName = @"Alfredo Fetuchini", SellerCity = @"London", Date = @"02/01/2012", Value = 20.6, NumberOfUnits = 237 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 87.8, SellerName = @"Claudia Kobayashi", SellerCity = @"Berlin", Date = @"02/13/2012", Value = 17.2, NumberOfUnits = 114 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 55.4, SellerName = @"Bryan Culver", SellerCity = @"London", Date = @"02/23/2012", Value = 76.8, NumberOfUnits = 329 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 40.8, SellerName = @"Howard Sprouse", SellerCity = @"Seattle", Date = @"02/24/2012", Value = 1.2, NumberOfUnits = 135 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 57.8, SellerName = @"Harold Garvin", SellerCity = @"New York", Date = @"03/02/2012", Value = 46.8, NumberOfUnits = 187 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 14.8, SellerName = @"David Haley", SellerCity = @"Tokyo", Date = @"03/10/2012", Value = 17.6, NumberOfUnits = 286 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 13, SellerName = @"Antonio Charbonneau", SellerCity = @"Mellvile", Date = @"03/11/2012", Value = 18.2, NumberOfUnits = 468 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 26, SellerName = @"Monica Freitag", SellerCity = @"Tokyo", Date = @"03/18/2012", Value = 93.2, NumberOfUnits = 71 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 72.6, SellerName = @"Bryan Culver", SellerCity = @"Mellvile", Date = @"03/21/2012", Value = 62, NumberOfUnits = 251 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 44.4, SellerName = @"Monica Freitag", SellerCity = @"Berlin", Date = @"03/25/2012", Value = 57.2, NumberOfUnits = 297 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 68.2, SellerName = @"Alfredo Fetuchini", SellerCity = @"Berlin", Date = @"03/25/2012", Value = 4.2, NumberOfUnits = 248 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 35.4, SellerName = @"Elisa Longbottom", SellerCity = @"Sofia", Date = @"03/26/2012", Value = 45.2, NumberOfUnits = 488 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 41.2, SellerName = @"Alfredo Fetuchini", SellerCity = @"Sofia", Date = @"04/06/2012", Value = 59.6, NumberOfUnits = 211 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 29.4, SellerName = @"Stanley Brooker", SellerCity = @"Seattle", Date = @"04/14/2012", Value = 3.2, NumberOfUnits = 149 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 52, SellerName = @"Lydia Burson", SellerCity = @"Berlin", Date = @"04/14/2012", Value = 9.8, NumberOfUnits = 99 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 57.8, SellerName = @"Benjamin Meekins", SellerCity = @"Seattle", Date = @"04/16/2012", Value = 14, NumberOfUnits = 225 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 26, SellerName = @"Nicholas Carmona", SellerCity = @"Seattle", Date = @"04/27/2012", Value = 95.4, NumberOfUnits = 408 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 5, SellerName = @"Benjamin Meekins", SellerCity = @"Sofia", Date = @"05/09/2012", Value = 40.2, NumberOfUnits = 417 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 3, SellerName = @"Alfredo Fetuchini", SellerCity = @"London", Date = @"05/24/2012", Value = 67.8, NumberOfUnits = 221 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 57.6, SellerName = @"Mark Slater", SellerCity = @"New York", Date = @"06/02/2012", Value = 45.4, NumberOfUnits = 288 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 72.4, SellerName = @"Bryan Culver", SellerCity = @"Berlin", Date = @"06/03/2012", Value = 92.8, NumberOfUnits = 372 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 82.6, SellerName = @"Kathe Pettel", SellerCity = @"Seattle", Date = @"06/03/2012", Value = 51.4, NumberOfUnits = 408 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 91.6, SellerName = @"Benjamin Dupree", SellerCity = @"Mellvile", Date = @"06/04/2012", Value = 28.6, NumberOfUnits = 13 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 94.8, SellerName = @"Benjamin Dupree", SellerCity = @"Mellvile", Date = @"06/05/2012", Value = 31.6, NumberOfUnits = 487 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 46.4, SellerName = @"Benjamin Dupree", SellerCity = @"Sofia", Date = @"06/11/2012", Value = 86, NumberOfUnits = 276 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 18.2, SellerName = @"Howard Sprouse", SellerCity = @"New York", Date = @"06/16/2012", Value = 40.2, NumberOfUnits = 490 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 48.8, SellerName = @"Harold Garvin", SellerCity = @"London", Date = @"06/18/2012", Value = 55.6, NumberOfUnits = 238 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 94.4, SellerName = @"David Haley", SellerCity = @"Tokyo", Date = @"06/23/2012", Value = 92, NumberOfUnits = 170 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 48.8, SellerName = @"Brandon Mckim", SellerCity = @"Mellvile", Date = @"07/04/2012", Value = 72.8, NumberOfUnits = 132 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 82.8, SellerName = @"Mark Slater", SellerCity = @"Mellvile", Date = @"07/05/2012", Value = 56.8, NumberOfUnits = 443 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 38.2, SellerName = @"Benjamin Dupree", SellerCity = @"New York", Date = @"07/05/2012", Value = 27.6, NumberOfUnits = 368 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 24.2, SellerName = @"Harold Garvin", SellerCity = @"New York", Date = @"07/11/2012", Value = 38.6, NumberOfUnits = 39 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 4, SellerName = @"Alfredo Fetuchini", SellerCity = @"Tokyo", Date = @"07/13/2012", Value = 43.2, NumberOfUnits = 95 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 81.8, SellerName = @"Benjamin Meekins", SellerCity = @"Berlin", Date = @"07/14/2012", Value = 42.6, NumberOfUnits = 42 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 75, SellerName = @"Brandon Mckim", SellerCity = @"Seattle", Date = @"07/16/2012", Value = 61.4, NumberOfUnits = 200 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 85.6, SellerName = @"Monica Freitag", SellerCity = @"Seattle", Date = @"07/16/2012", Value = 10.6, NumberOfUnits = 221 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 96.4, SellerName = @"Larry Lieb", SellerCity = @"New York", Date = @"07/21/2012", Value = 99.6, NumberOfUnits = 54 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 46.2, SellerName = @"Lydia Burson", SellerCity = @"Tokyo", Date = @"07/21/2012", Value = 56, NumberOfUnits = 173 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 99.8, SellerName = @"Lydia Burson", SellerCity = @"London", Date = @"07/23/2012", Value = 10.8, NumberOfUnits = 47 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 42.4, SellerName = @"Kathe Pettel", SellerCity = @"Mellvile", Date = @"07/26/2012", Value = 91.6, NumberOfUnits = 173 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 52.2, SellerName = @"Claudia Kobayashi", SellerCity = @"Mellvile", Date = @"08/05/2012", Value = 98.8, NumberOfUnits = 323 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 45.6, SellerName = @"Russell Shorter", SellerCity = @"Sofia", Date = @"08/07/2012", Value = 26, NumberOfUnits = 264 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 56.8, SellerName = @"Mark Slater", SellerCity = @"Sofia", Date = @"08/09/2012", Value = 11.6, NumberOfUnits = 385 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 3.6, SellerName = @"Harry Tyler", SellerCity = @"London", Date = @"08/10/2012", Value = 26, NumberOfUnits = 56 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 34.6, SellerName = @"Benjamin Dupree", SellerCity = @"Berlin", Date = @"08/12/2012", Value = 96.2, NumberOfUnits = 267 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 92.4, SellerName = @"Monica Freitag", SellerCity = @"Seattle", Date = @"08/14/2012", Value = 95, NumberOfUnits = 109 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 34.8, SellerName = @"Mark Slater", SellerCity = @"Berlin", Date = @"08/17/2012", Value = 62.4, NumberOfUnits = 478 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 23.4, SellerName = @"Claudia Kobayashi", SellerCity = @"Berlin", Date = @"08/21/2012", Value = 57.8, NumberOfUnits = 184 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 79.6, SellerName = @"Brandon Mckim", SellerCity = @"Seattle", Date = @"08/21/2012", Value = 35.4, NumberOfUnits = 132 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 30.8, SellerName = @"Nicholas Carmona", SellerCity = @"Sofia", Date = @"08/22/2012", Value = 96, NumberOfUnits = 142 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 90, SellerName = @"Carl Costello", SellerCity = @"Seattle", Date = @"08/27/2012", Value = 27.6, NumberOfUnits = 46 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 83.2, SellerName = @"Walter Pang", SellerCity = @"Seattle", Date = @"09/03/2012", Value = 68.6, NumberOfUnits = 102 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 0.2, SellerName = @"Russell Shorter", SellerCity = @"Berlin", Date = @"09/09/2012", Value = 96.6, NumberOfUnits = 21 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 36.6, SellerName = @"Monica Freitag", SellerCity = @"Sofia", Date = @"09/10/2012", Value = 5, NumberOfUnits = 442 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 92.4, SellerName = @"Harry Tyler", SellerCity = @"New York", Date = @"09/13/2012", Value = 99.2, NumberOfUnits = 254 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 28, SellerName = @"Nicholas Carmona", SellerCity = @"Sofia", Date = @"09/13/2012", Value = 50, NumberOfUnits = 251 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 60.4, SellerName = @"Antonio Charbonneau", SellerCity = @"New York", Date = @"09/15/2012", Value = 44, NumberOfUnits = 119 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Bikes", ProductUnitPrice = 33, SellerName = @"Claudia Kobayashi", SellerCity = @"New York", Date = @"09/19/2012", Value = 32.4, NumberOfUnits = 256 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 99, SellerName = @"John Smith", SellerCity = @"New York", Date = @"09/23/2012", Value = 35.8, NumberOfUnits = 456 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 16.2, SellerName = @"Kathe Pettel", SellerCity = @"London", Date = @"10/01/2012", Value = 16.4, NumberOfUnits = 430 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 73, SellerName = @"David Haley", SellerCity = @"Berlin", Date = @"10/02/2012", Value = 57, NumberOfUnits = 248 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 21.8, SellerName = @"Harold Garvin", SellerCity = @"Berlin", Date = @"10/18/2012", Value = 28.2, NumberOfUnits = 440 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 28.4, SellerName = @"Howard Sprouse", SellerCity = @"New York", Date = @"10/19/2012", Value = 66.6, NumberOfUnits = 234 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 80.6, SellerName = @"Benjamin Meekins", SellerCity = @"New York", Date = @"10/25/2012", Value = 5.4, NumberOfUnits = 36 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Accessories", ProductUnitPrice = 97.8, SellerName = @"Harry Tyler", SellerCity = @"London", Date = @"10/26/2012", Value = 41.2, NumberOfUnits = 46 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 88.8, SellerName = @"Elisa Longbottom", SellerCity = @"London", Date = @"11/02/2012", Value = 64.6, NumberOfUnits = 211 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Clothing", ProductUnitPrice = 67.4, SellerName = @"Walter Pang", SellerCity = @"New York", Date = @"11/17/2012", Value = 14.2, NumberOfUnits = 408 });
        this.Add(new PivotDataFlatItem() { ProductName = @"Components", ProductUnitPrice = 7.2, SellerName = @"Walter Pang", SellerCity = @"New York", Date = @"11/20/2012", Value = 72.8, NumberOfUnits = 376 });
    }
}csCOPY CODE

@using IgniteUI.Blazor.Controls

@inject IJSRuntime JS

<div class="container vertical ig-typography">
    <div class="container vertical fill">
        <IgbPivotGrid
        Data="PivotDataFlat"
        Name="grid"
        @ref="grid"
        RowSelection="GridSelectionMode.Single"
        SuperCompactMode="true"
        PivotConfiguration="PivotConfiguration1">
        </IgbPivotGrid>

    </div>
</div>

@code {
    

    protected override async Task OnAfterRenderAsync(bool firstRender)
    {
        var grid = this.grid;

    }

    private IgbPivotGrid grid;
    private IgbPivotConfiguration _pivotConfiguration1 = null;
    public IgbPivotConfiguration PivotConfiguration1
    {
        get
        {
            if (this._pivotConfiguration1 == null)
            {
                var pivotConfiguration1 = new IgbPivotConfiguration();
                var pivotDateDimension1 = new IgbPivotDateDimension();
                pivotDateDimension1.MemberName = "Date";
                pivotDateDimension1.Enabled = true;
                pivotDateDimension1.Name = "pivotDateDimension1";var pivotDimension1 = new IgbPivotDimension();
                pivotDimension1.MemberName = "Date";
                pivotDimension1.Enabled = true;
                pivotDimension1.Name = "pivotDimension1";pivotDateDimension1.BaseDimension = pivotDimension1;
                var pivotDateDimensionOptions1 = new IgbPivotDateDimensionOptions();
                pivotDateDimensionOptions1.Years = true;
                pivotDateDimensionOptions1.Months = false;
                pivotDateDimensionOptions1.Quarters = true;
                pivotDateDimensionOptions1.FullDate = false;
                pivotDateDimensionOptions1.Name = "pivotDateDimensionOptions1";pivotDateDimension1.Options = pivotDateDimensionOptions1;
                pivotConfiguration1.Columns = [pivotDateDimension1];
                var pivotDimension2 = new IgbPivotDimension();
                pivotDimension2.MemberName = "ProductName";
                pivotDimension2.SortDirection = SortingDirection.Asc;
                pivotDimension2.Enabled = true;
                pivotDimension2.Name = "pivotDimension2";var pivotDimension3 = new IgbPivotDimension();
                pivotDimension3.MemberName = "SellerCity";
                pivotDimension3.Enabled = true;
                pivotDimension3.Name = "pivotDimension3";pivotConfiguration1.Rows = [pivotDimension2,pivotDimension3];
                var pivotDimension4 = new IgbPivotDimension();
                pivotDimension4.MemberName = "SellerName";
                pivotDimension4.Enabled = true;
                pivotDimension4.Name = "pivotDimension4";pivotConfiguration1.Filters = [pivotDimension4];
                var pivotValue1 = new IgbPivotValue();
                pivotValue1.Member = "AmountofSale";
                pivotValue1.DisplayName = "Amount of Sale";
                pivotValue1.Enabled = true;
                pivotValue1.Name = "pivotValue1";var pivotAggregator1 = new IgbPivotAggregator();
                pivotAggregator1.Key = "SUM";
                pivotAggregator1.Label = "Sum of Sale";
                pivotAggregator1.AggregatorScript = "PivotDataFlatAggregateSumSale";
                pivotAggregator1.Name = "pivotAggregator1";pivotValue1.Aggregate = pivotAggregator1;
                var pivotAggregator2 = new IgbPivotAggregator();
                pivotAggregator2.Key = "SUM";
                pivotAggregator2.Label = "Sum of Sale";
                pivotAggregator2.AggregatorScript = "PivotDataFlatAggregateSumSale";
                pivotAggregator2.Name = "pivotAggregator2";var pivotAggregator3 = new IgbPivotAggregator();
                pivotAggregator3.Key = "MIN";
                pivotAggregator3.Label = "Minimum of Sale";
                pivotAggregator3.AggregatorScript = "PivotDataFlatAggregateMinSale";
                pivotAggregator3.Name = "pivotAggregator3";var pivotAggregator4 = new IgbPivotAggregator();
                pivotAggregator4.Key = "MAX";
                pivotAggregator4.Label = "Maximum of Sale";
                pivotAggregator4.AggregatorScript = "PivotDataFlatAggregateMaxSale";
                pivotAggregator4.Name = "pivotAggregator4";pivotValue1.AggregateList = [pivotAggregator2,pivotAggregator3,pivotAggregator4];
                pivotConfiguration1.Values = [pivotValue1];

                this._pivotConfiguration1 = pivotConfiguration1;
            }
            return this._pivotConfiguration1;
        }
    }

    private PivotDataFlat _pivotDataFlat = null;
    public PivotDataFlat PivotDataFlat
    {
        get
        {
            if (_pivotDataFlat == null)
            {
                _pivotDataFlat = new PivotDataFlat();
            }
            return _pivotDataFlat;
        }
    }

}razorCOPY CODE

igRegisterScript("PivotDataFlatAggregateSumSale", (members, data) => {
    return data.reduce((accumulator, value) => accumulator + value.ProductUnitPrice * value.NumberOfUnits, 0);
}, false);

igRegisterScript("PivotDataFlatAggregateMinSale", (members, data) => {
    let min = 0;
    if (data.length === 1) {
        min = data[0].ProductUnitPrice * data[0].NumberOfUnits;
    } else if (data.length > 1) {
        const mappedData = data.map(x => x.ProductUnitPrice * x.NumberOfUnits);
        min = mappedData.reduce((a, b) => Math.min(a, b));
    }
    return min;
}, false);

igRegisterScript("PivotDataFlatAggregateMaxSale", (members, data) => {
    let max = 0;
    if (data.length === 1) {
        max = data[0].ProductUnitPrice * data[0].NumberOfUnits;
    } else if (data.length > 1) {
        const mappedData = data.map(x => x.ProductUnitPrice * x.NumberOfUnits);
        max = mappedData.reduce((a, b) => Math.max(a, b));
    }
    return max;
}, false);

jsCOPY CODE

/*
CSS styles are loaded from the shared CSS file located at:
https://static.infragistics.com/xplatform/css/samples/
*/
cssCOPY CODE

Dimensions Sorting

Dimension values in the rows or columns can be sorted via the related chip or the API. This functionality is embedded and enabled by default.

The dimension is sorted on click of the related chip and as a result the dimension values are sorted in ascending/descending order.

Sorting can also be applied initially via the sortDirection property of the dimension definition.

    var pivotConfiguration = new IgbPivotConfiguration();
    var rowDimension = new IgbPivotDimension() {
        MemberName = "SellerName",
        Enabled = true,
        SortDirection = SortingDirection.Asc
    };
    pivotConfiguration.Rows.Add(rowDimension);
razor

Dimensions Resizing

Row dimensions can be resized similarly to column resizing - via a resizing indicator that can be found on the right edge of the cells. They can also be auto-sized by double clicking the resize indicator, or by using the related API - AutoSizeRowDimension.

A different size can also be set initially with the Width property available in the dimension definition:

    var pivotConfiguration = new IgbPivotConfiguration();
    var rowDimension = new IgbPivotDimension() {
        MemberName = "SellerName",
        Enabled = true,
        Width = "400px"
    };
    pivotConfiguration.Rows.Add(rowDimension);
razor

Dimensions Selection

The Pivot Grid supports single selection which is enabled just like in the base grid. For example:

<IgbPivotGrid PivotConfiguration="PivotConfiguration"
        Data="PivotSalesData"
        Name="grid"
        RowSelection=GridSelectionMode.Single
        @ref="grid">
</IgbPivotGrid>
razor

In case there are multiple row or column dimensions which would create groups that span multiple rows/columns, selection is applied to all cells that belong to the selected group.

Super Compact Mode

The IgbPivotGrid component provides a SuperCompactMode input. It is suitable for cases that require a lot of cells to be present on the screen at once. If enabled the option ignores the --ig-size CSS variable for the Pivot Grid. Enabling SuperCompactMode also sets the --ig-size to small for each child component(like IgbChip) that does not have the SuperCompactMode option.

<IgbPivotGrid SuperCompactMode=true></IgbPivotGrid>
razor

Additional Summary Column

When a column dimension defines a hierarchy, the Pivot Grid will render additional summary/total column, which accumulates the aggregations of all of the columns inside the group. When the group is collapsed only the summary column will remain. And when the group is expanded the additional summary column appears at the end of the group.

Interactions

Keyboard Navigation

Keyboard navigation in IgbPivotGrid works similarly to the one in IgbGrid. The Pivot Grid is split into three areas - rows, columns, values. The areas for rows and columns are considered headers for the purposes of navigation while the area for values is the body. The keyboard arrows allow navigating the active element within the current area only.

Dimensions Drag & Drop

The dimensions are represented by chips, which can be dragged & dropped. All chips can change their order within their area by drag & drop. The chips from rows, column, filter(dimension chips) can be moved from any of those areas to any other and at any place. Chips from these areas can not be moved to the values area and chips from the values area can not be moved to any of the dimension areas.

The chips from the Pivot Grid can not be moved to the Pivot Data Selector and items from the Pivot Data Selector can not be moved to the Pivot Grid.

API References

• IgbPivotGrid
• IgbPivotDataSelector

Additional Resources

• Ignite UI for Blazor Forums
• Ignite UI for Blazor GitHub