Blazor Pivot Grid 機能

ピボットおよびフラット グリッド コンポーネントは、共通ベースを継承しているため、いくつかの機能を共有しています。

一部の機能は、ピボット テーブルのコンテキストで意味のある動作をしないため IgbPivotGrid で有効にできません。以下が含まれます。 CRUD 操作 グループ化 行 / 列のピン固定 集計 ページング

Pivot Grid コンポーネントには、以下で説明するように、そのディメンションに関連する追加の機能があります。

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();
        }
    }
}csコピー

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
        });
    }
}csコピー

@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;
        }
    }

}razorコピー

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);

jsコピー

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

このサンプルが気に入りましたか? 完全な Ignite UI for Blazorツールキットにアクセスして、すばやく独自のアプリの作成を開始します。無料でダウンロードできます。

すぐに使用できる機能のフルセット は、ページング、ソート、フィルタリング、編集、グループ化から行と列の仮想化まで、あらゆる機能をカバーします。.NET 開発者には制限はありません。

無料で試してみる

ディメンションのソート

rows (行) または columns (列) のディメンション値は、関連するチップまたは API を介して並べ替えることができます。この機能は埋め込まれており、デフォルトで有効になっています。

関連するチップをクリックするとディメンションが並べ替えられ、その結果、ディメンション値が昇順 / 降順で並べ替えられます。

並べ替えは、ディメンション定義の sortDirection プロパティを介して最初に適用することもできます。

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

ディメンションのサイズ変更

行のサイズは、列のサイズ変更と同様に、セルの右端にあるサイズ変更インジケーターを介してサイズ変更できます。 サイズ変更インジケーターをダブル クリックするか、関連する API (AutoSizeRowDimension) を使用して、自動サイズ設定することもできます。

ディメンション定義で使用可能な Width プロパティを使用して、最初に別のサイズを設定することもできます。

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

ディメンションの選択

Pivot Grid は、ベース グリッドと同じように有効になる単一選択をサポートします。例:

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

複数の行 / 列にまたがるグループを作成する複数の行または列のディメンションがある場合、選択は、選択されたグループに属するすべてのセルに適用されます。

スーパー コンパクト モード

IgbPivotGrid コンポーネントは、SuperCompactMode 入力を提供します。一度にたくさんのセルが画面に表示させる必要がある場合に適しています。有効にすると、このオプションは Pivot Grid の --ig-size CSS 変数を無視します。SuperCompactMode を有効にすると、SuperCompactMode オプションがない子コンポーネント (IgbChip など) ごとに --ig-size が small に設定されます。

<IgbPivotGrid SuperCompactMode=true></IgbPivotGrid>
razor

追加の集計列

column ディメンションが階層を定義すると、Pivot Grid は追加の集計 / 合計列を描画し、グループ内のすべての列の集計を蓄積します。グループが縮小されている場合、集計列のみが残ります。また、グループを展開すると、グループの最後に追加の集計列が表示されます。

インタラクション

キーボード ナビゲーション

IgbPivotGrid のキーボード ナビゲーションは、IgbGrid キーボード ナビゲーションと同様に機能します。Pivot Grid は、rows、columns、values の 3 つの領域に分割されます。rows と columns の領域はナビゲーションの目的でヘッダーと見なされ、values の領域は本文です。 キーボードの矢印を使用すると、現在の領域内でのみアクティブな要素をナビゲートできます。

ディメンションのドラッグアンドドロップ

ディメンションはチップで表現され、ドラッグアンドドロップが可能です。 すべてのチップは、ドラッグアンドドロップでエリア内の順序を変更できます。 rows、column、filter (ディメンション チップ) のチップは、これらの領域のいずれかから他の任意の場所に移動できます。 これらの領域のチップは values 領域に移動できず、values 領域のチップはどのディメンション領域にも移動できません。

Pivot Grid のチップをピボット データ セレクターに移動したり、ピボット データ セレクターの項目を Pivot Grid に移動したりすることはできません。

API リファレンス

• IgbPivotGrid
• IgbPivotDataSelector

その他のリソース

• Ignite UI for Blazor フォーラム (英語)
• Ignite UI for Blazor GitHub (英語)