Blazor Pivot Grid State Persistence

Blazor Pivot Grid의 Ignite UI for Blazor 상태 지속성을 통해 개발자는 그리드 상태를 쉽게 저장하고 복원할 수 있습니다. Blazor IgbGridState​ ​IgbPivotGrid에 적용되면 개발자가 모든 시나리오에서 상태 유지를 달성하는 데 사용할 수 있는 및 ApplyStateFromStringAsync 메서드가 노출 GetStateAsStringAsync 됩니다.

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

無料で試してみる

Supported Features

IgbGridState 지시문은 다음 기능의 상태 저장 및 복원을 지원합니다.

• Sorting
• Filtering
• CellSelection
• ColumnSelection
• Expansion
• PivotConfiguration
  • Pivot Configuration properties defined by the IPivotConfiguration interface.
  • 피벗 차원 및 값 기능은 애플리케이션 수준 코드를 사용하여 복원됩니다. 피벗 구성 복원 섹션을 참조하세요.

Usage

직렬화된 JSON 문자열을 GetStateAsStringAsync 반환하므로 개발자는 이를 가져와서 모든 데이터 저장소(데이터베이스, 클라우드, 브라우저 localStorage 등)에 저장할 수 있습니다.

개발자는 기능 이름이 있는 배열을 인수로 전달하여 특정 기능에 대한 상태만 가져오도록 선택할 수 있습니다. 빈 배열은 기본 상태 옵션을 사용하게 됩니다.

<IgbPivotGrid>
    <IgbGridState @ref="gridState"></IgbGridState>
</IgbPivotGrid>

@code {
    // get all features` state in a serialized JSON string
    string stateString = gridState.GetStateAsStringAsync(new string[0]);

    // get the sorting and filtering expressions
    string sortingFilteringStates = gridState.GetStateAsStringAsync(new string[] { "sorting", "filtering" });
}
razor

ApplyStateFromStringAsync- 이 메서드는 직렬화된 JSON 문자열을 인수로 허용하고 JSON 문자열 또는 지정된 기능에 있는 각 기능의 상태를 두 번째 인수로 복원합니다.

gridState.ApplyStateFromStringAsync(gridStateString, new string[0]);
gridState.ApplyStateFromStringAsync(sortingFilteringStates, new string[0])
razor

객체는 Options 인터페이스를 구현 IgbGridStateOptions 합니다, 즉 특정 기능의 이름인 모든 키에 대해 이 기능 상태가 추적되는지 여부를 나타내는 부울 값이 있습니다. GetStateAsStringAsync 메서드는 이러한 기능의 상태를 반환된 값에 넣지 않으며 ApplyStateFromStringAsync 메서드는 해당 기능의 상태를 복원하지 않습니다.

gridState.Options = new IgbGridStateOptions
    {
        CellSelection = false,
        Sorting = false
    };
razor

사용하기 쉬운 단일 지점 API를 사용하면 몇 줄의 코드로 전체 상태 유지 기능을 얻을 수 있습니다. 아래에서 코드를 복사하여 붙여 넣 으십시오 - 사용자가 현재 페이지를 떠날 때마다 브라우저 LocalStorage 개체에 그리드 상태를 저장합니다. 사용자가 기본 페이지로 돌아갈 때마다 그리드 상태가 복원됩니다. 더 이상 원하는 데이터를 얻기 위해 매번 복잡한 고급 필터링 및 정렬 표현식을 구성할 필요가 없습니다 - 한 번만 수행하고 아래 코드가 사용자를 위해 나머지 작업을 수행하도록 합니다.

@using IgniteUI.Blazor.Controls
@using Newtonsoft.Json
@implements IDisposable

@inject IJSRuntime JS
@inject NavigationManager Navigation

<IgbPivotGrid Rendered="OnGridRendered">
    <IgbGridState @ref="gridState"></IgbGridState>
    <IgbColumn Field="ContactName" Header="Name" MinWidth="200px" ></IgbColumn>
    <IgbColumn Field="ContactTitle" Header="Title" MinWidth="200px" Sortable="true" Filterable="true" Groupable="true"></IgbColumn>
    <IgbColumn Field="CompanyName" Header="Company" MinWidth="200px" Sortable="true" Filterable="true" Groupable="true"></IgbColumn>
</IgbPivotGrid>

@code {
    protected override void OnAfterRender(bool firstRender)
    {
        Navigation.LocationChanged += OnLocationChanged;
    }

    void OnLocationChanged(object sender, LocationChangedEventArgs e)
    {
        SaveGridState();
    }

    void IDisposable.Dispose()
    {
        // Unsubscribe from the event when our component is disposed
        Navigation.LocationChanged -= OnLocationChanged;
    }

    void OnGridRendered()
    {
        RestoreGridState();
    }

    async void SaveGridState() {
        string state = gridState.GetStateAsStringAsync(new string[0]);
        await JS.InvokeVoidAsync("window.localStorage.setItem", "grid-state", state);
    }

    async void RestoreGridState() {
        string state = await JS.InvokeAsync<string>("window.localStorage.getItem", "grid-state");
        if (state) {
            gridState.ApplyStateFromStringAsync(state, new string[0]);
        }
    }
}
razor

Restoring Pivot Configuration

IgbGridState 기본적으로 pivot dimension 함수, value formatter 등을 유지하지 않습니다(제한 사항 참조). 이러한 복원은 응용 프로그램 수준에서 코드를 사용하여 수행할 수 있습니다. IgbPivotGrid configuration: DimensionInit and에 있는 사용자 정의 함수를 다시 설정하는 데 사용할 수 있는 두 개의 이벤트를 노출합니다 ValueInit. 이 작업을 수행하는 방법을 보여 드리겠습니다.

• 및 ValueInit 이벤트에 대한 이벤트 처리기를 DimensionInit 할당합니다.

    <IgbPivotGrid
        @ref="grid"
        Width="95%"
        Height="500px"
        PivotConfiguration="PivotConfiguration"
        ValueInitScript="OnValueInit">
    </IgbPivotGrid>
razor

​DimensionInit 및 ValueInit 이벤트는 속성에 정의된 각 값과 차원에 대해 내보내집니다 PivotConfiguration.

• 이벤트 처리기에서 ValueInit 모든 사용자 지정 집계자, 포맷터 및 스타일을 설정합니다.

// In Javascript
const totalSale = (members, data) => {
    return data.reduce((accumulator, value) => accumulator + value.ProductUnitPrice * value.NumberOfUnits, 0);
};

const totalMin = (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;
};

const totalMax = (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;
};

igRegisterScript("OnValueInit", (args) => {
    const value = args.detail;
    if (value.member === "AmountOfSale") {
      value.aggregate.aggregator = totalSale;
      value.aggregateList?.forEach((aggr) => {
        switch (aggr.key) {
          case "SUM":
            aggr.aggregator = totalSale;
            break;
          case "MIN":
            aggr.aggregator = totalMin;
            break;
          case "MAX":
            aggr.aggregator = totalMax;
            break;
        }
      });
    }
}, false);
razor

Demo

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(IgbGridModule),
                typeof(IgbIconModule),
                typeof(IgbCheckboxModule)
            );
            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
@implements IDisposable

@inject IJSRuntime JS
@inject NavigationManager Navigation

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

.horizontal {
    gap: 10px;
    flex-basis: fit-content;
    flex-wrap: wrap;
}

.sampleContainer {
    padding: 0.5rem
}
</style>
<div class="container vertical">

    <div class="container vertical sampleContainer">
        <div class="container horizontal">
            <IgbButton @onclick="RestoreGridState">
                <IgbIcon @ref="IconRef" IconName="restore" Collection="material"></IgbIcon>
                <span>Restore</span>
            </IgbButton>
            <IgbButton @onclick="SaveGridState">
                <IgbIcon IconName="save" Collection="material"></IgbIcon>
                <span>Save</span>
            </IgbButton>
            <IgbButton @onclick="ResetGridState">
                <IgbIcon IconName="clear" Collection="material"></IgbIcon>
                <span>Reset</span>
            </IgbButton>
            <IgbButton @onclick="LeavePage">
                <IgbIcon IconName="forward" Collection="material"></IgbIcon>
                <span>Leave</span>
            </IgbButton>
            <IgbButton @onclick="ClearStorage">
                <IgbIcon IconName="delete" Collection="material"></IgbIcon>
                <span>Clear</span>
            </IgbButton>
            <IgbButton @onclick="ReloadPage">
                <IgbIcon IconName="refresh" Collection="material"></IgbIcon>
                <span>Reload</span>
            </IgbButton>
        </div>
        <div class="container horizontal">
            <ul>
                <li>Clicking the SAVE button or leaving the page <a id="leaveLink" href="./grids/pivot-grid/state-persistence-about"><strong>here</strong></a> will save grid state to localStorage.</li>
                <li>Use the control buttons to SAVE / RESTORE / RESET / DELETE / grid state or LEAVE the page.</li>
                <li>Select/Deselect checkboxes to control saving / restoring feature state.</li>
            </ul>
        </div>
        <div class="container horizontal">
            <IgbCheckbox Change="@((evt) => OnChange(evt, "AllFeatures"))" Checked="allOptions">All Features</IgbCheckbox>
            <IgbCheckbox Change="@((evt) => OnChange(evt, "CellSelection"))" Checked="options.CellSelection">Cell Selection</IgbCheckbox>
            <IgbCheckbox Change="@((evt) => OnChange(evt, "ColumnSelection"))" Checked="options.ColumnSelection">Col Selection</IgbCheckbox>
            <IgbCheckbox Change="@((evt) => OnChange(evt, "Expansion"))" Checked="options.Expansion">Expansion</IgbCheckbox>
            <IgbCheckbox Change="@((evt) => OnChange(evt, "Filtering"))" Checked="options.Filtering">Filtering</IgbCheckbox>
            <IgbCheckbox Change="@((evt) => OnChange(evt, "Sorting"))" Checked="options.Sorting">Sorting</IgbCheckbox>
            <IgbCheckbox Change="@((evt) => OnChange(evt, "PivotConfiguration"))" Checked="options.PivotConfiguration">Pivot Configuration</IgbCheckbox>
        </div>
        <IgbPivotGrid
            @ref="grid"
            Width="95%"
            Height="500px"
            Data="PivotDataFlat"
            PivotConfiguration="PivotConfiguration"
            ColumnSelection="GridSelectionMode.Single"
            ValueInitScript="OnValueInit"
            Rendered="OnGridRendered">
            <IgbGridState @ref="gridState"></IgbGridState>
        </IgbPivotGrid>
    </div>
</div>

@code {

    private string restoreIcon = "<svg xmlns='http://www.w3.org/2000/svg' height='24' viewBox='0 -960 960 960' width='24'><path d='M480-120q-138 0-240.5-91.5T122-440h82q14 104 92.5 172T480-200q117 0 198.5-81.5T760-480q0-117-81.5-198.5T480-760q-69 0-129 32t-101 88h110v80H120v-240h80v94q51-64 124.5-99T480-840q75 0 140.5 28.5t114 77q48.5 48.5 77 114T840-480q0 75-28.5 140.5t-77 114q-48.5 48.5-114 77T480-120Zm112-192L440-464v-216h80v184l128 128-56 56Z'/></svg>";
    private string saveIcon = "<svg xmlns='http://www.w3.org/2000/svg' height='24px' viewBox='0 0 24 24' width='24px' fill='#000000'><path d='M0 0h24v24H0V0z' fill='none'/><path d='M17 3H5c-1.11 0-2 .9-2 2v14c0 1.1.89 2 2 2h14c1.1 0 2-.9 2-2V7l-4-4zm2 16H5V5h11.17L19 7.83V19zm-7-7c-1.66 0-3 1.34-3 3s1.34 3 3 3 3-1.34 3-3-1.34-3-3-3zM6 6h9v4H6z'/></svg>";
    private string clearIcon = "<svg xmlns='http://www.w3.org/2000/svg' height='24' viewBox='0 -960 960 960' width='24'><path d='m256-200-56-56 224-224-224-224 56-56 224 224 224-224 56 56-224 224 224 224-56 56-224-224-224 224Z'/></svg>";
    private string forwardIcon = "<svg xmlns='http://www.w3.org/2000/svg' height='24' viewBox='0 -960 960 960' width='24'><path d='M647-440H160v-80h487L423-744l57-56 320 320-320 320-57-56 224-224Z'/></svg>";
    private string deleteIcon = "<svg xmlns='http://www.w3.org/2000/svg' height='24' viewBox='0 -960 960 960' width='24'><path d='M280-120q-33 0-56.5-23.5T200-200v-520h-40v-80h200v-40h240v40h200v80h-40v520q0 33-23.5 56.5T680-120H280Zm400-600H280v520h400v-520ZM360-280h80v-360h-80v360Zm160 0h80v-360h-80v360ZM280-720v520-520Z'/></svg>";
    private string refreshIcon = "<svg xmlns='http://www.w3.org/2000/svg' height='24' viewBox='0 -960 960 960' width='24'><path d='M480-160q-134 0-227-93t-93-227q0-134 93-227t227-93q69 0 132 28.5T720-690v-110h80v280H520v-80h168q-32-56-87.5-88T480-720q-100 0-170 70t-70 170q0 100 70 170t170 70q77 0 139-44t87-116h84q-28 106-114 173t-196 67Z'/></svg>";

    private IgbPivotGrid grid;
    private IgbGridState gridState;
    private IgbPaginator paginator;
    private bool allOptions = true;
    private IgbGridStateOptions options = new IgbGridStateOptions()
    {
        CellSelection = true,
        Filtering = true,
        Sorting = true,
        Expansion = true,
        ColumnSelection = true,
        PivotConfiguration = true
    };
    private string stateKey = "pivot-grid-state";
    private IgbIcon IconRef;
    private IDisposable registration;

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

    private IgbPivotConfiguration _pivotConfiguration;
    public IgbPivotConfiguration PivotConfiguration
    {
        get
        {
            if (_pivotConfiguration == null) {
                var pivotConfiguration = new IgbPivotConfiguration();
                var dateBaseDimension = new IgbPivotDimension() {
                    MemberName = "Date",
                    Enabled = true
                };
                var dateDimensionOptions = new IgbPivotDateDimensionOptions() {
                    Months = false,
                    Quarters = true,
                    FullDate = false
                };
                var pivotDateDimension = new IgbPivotDateDimension() {
                    BaseDimension = dateBaseDimension,
                    Options = dateDimensionOptions,
                    Enabled = true
                };
                pivotDateDimension.BaseDimension = dateBaseDimension;
                pivotConfiguration.Columns = [pivotDateDimension];

                var productNameDimension = new IgbPivotDimension() {
                    MemberName = "ProductName",
                    Enabled = true
                };
                var sellerCityDimension = new IgbPivotDimension() {
                    MemberName = "SellerCity",
                    Enabled = true
                };
                pivotConfiguration.Rows = [productNameDimension, sellerCityDimension];

                var sellerNameDimension = new IgbPivotDimension() {
                    MemberName = "SellerName",
                    Enabled = true
                };
                pivotConfiguration.Filters = [sellerNameDimension];

                var pivotValue = new IgbPivotValue() {
                    Member = "Value",
                    Aggregate = new IgbPivotAggregator() {
                        Key = "SUM",
                        AggregatorName = PivotAggregationType.SUM,
                        Label = "Sum"
                    },
                    Enabled = true,
                    AggregateList = new IgbPivotAggregator[] {
                        new IgbPivotAggregator() {
                            Key = "SUM",
                            AggregatorName = PivotAggregationType.SUM,
                            Label = "Sum"
                        }
                    }
                };

                var amountOfSaleValue = new IgbPivotValue() {
                    Member = "AmountOfSale",
                    DisplayName = "Amount of Sale",
                    Enabled = true,
                    Aggregate = new IgbPivotAggregator() {
                        Key = "SUM",
                        Label = "Sum of Sale",
                        AggregatorScript = "PivotDataFlatAggregateSumSale"
                    },
                    AggregateList = new IgbPivotAggregator[] {
                        new IgbPivotAggregator() {
                            Key = "SUM",
                            Label = "Sum of Sale",
                            AggregatorScript = "PivotDataFlatAggregateSumSale"
                        },
                        new IgbPivotAggregator() {
                            Key = "MIN",
                            Label = "Minimum of Sale",
                            AggregatorScript = "PivotDataFlatAggregateMinSale"
                        },
                        new IgbPivotAggregator() {
                            Key = "MAX",
                            Label = "Maximum of Sale",
                            AggregatorScript = "PivotDataFlatAggregateMaxSale"
                        }
                    }
                };
            pivotConfiguration.Values = [pivotValue, amountOfSaleValue];
            _pivotConfiguration = pivotConfiguration;
            }
            return _pivotConfiguration;
        }
    }
    

    protected override void OnAfterRender(bool firstRender)
    {
        var grid = this.grid;
        if (this.IconRef != null && firstRender)
        {
            this.IconRef.EnsureReady().ContinueWith(new Action<Task>((e) =>
            {
                this.IconRef.RegisterIconFromText("restore", restoreIcon, "material");
                this.IconRef.RegisterIconFromText("save", saveIcon, "material");
                this.IconRef.RegisterIconFromText("clear", clearIcon, "material");
                this.IconRef.RegisterIconFromText("forward", forwardIcon, "material");
                this.IconRef.RegisterIconFromText("delete", deleteIcon, "material");
                this.IconRef.RegisterIconFromText("refresh", refreshIcon, "material");
            }));
        }
        if (firstRender)
        {
            registration = Navigation.RegisterLocationChangingHandler(OnLocationChanged);
        }
    }

    ValueTask OnLocationChanged(LocationChangingContext arg)
    {
        SaveGridState();
        return ValueTask.CompletedTask;
    }

    public void Dispose()
    {
        registration?.Dispose();
    }

    async void SaveGridState()
    {
        string state = await gridState.GetStateAsStringAsync(new string[0]);
        await JS.InvokeVoidAsync("window.localStorage.setItem", stateKey, state);
    }

    async void RestoreGridState()
    {
        string state = await JS.InvokeAsync<string>("window.localStorage.getItem", stateKey);
        if (state != null)
        {
            await gridState.ApplyStateFromStringAsync(state, new string[0]);
        }
    }

    void ResetGridState()
    {
        grid.GetAllDimensions().ToList().ForEach(dim => {
            grid.ClearFilter(dim.MemberName);
        });
        grid.SortingExpressions = new IgbSortingExpression[0];
        grid.DeselectAllColumns();
        grid.ClearCellSelection();
    }

    void OnChange(IgbCheckboxChangeEventArgs eventArgs, string action)
    {
        if (action == "AllFeatures")
        {
            var newOptions = new IgbGridStateOptions()
            {
                CellSelection = eventArgs.Detail.Checked,
                Filtering = eventArgs.Detail.Checked,
                Sorting = eventArgs.Detail.Checked,
                Expansion = eventArgs.Detail.Checked,
                ColumnSelection = eventArgs.Detail.Checked,
                PivotConfiguration = eventArgs.Detail.Checked
            };
            options = newOptions;
            gridState.Options = newOptions;
        }
        else
        {
            var newOptions = new IgbGridStateOptions();
            options.GetType().GetProperty(action).SetValue(newOptions, eventArgs.Detail.Checked);
            gridState.Options = newOptions;
        }
    }

    public void OnGridRendered()
    {
        RestoreGridState();
    }

    async void LeavePage()
    {
        SaveGridState();
        await JS.InvokeVoidAsync("window.location.replace", "./grids/pivot-grid/state-persistence-about");
    }

    async void ClearStorage()
    {
        await JS.InvokeVoidAsync("window.localStorage.removeItem", stateKey);
    }

    async void ReloadPage()
    {
        await JS.InvokeVoidAsync("window.location.reload");
    }
}razorコピー

const totalSale = (members, data) => {
    return data.reduce((accumulator, value) => accumulator + value.ProductUnitPrice * value.NumberOfUnits, 0);
};

const totalMin = (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;
};

const totalMax = (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;
};


igRegisterScript("PivotDataFlatAggregateSumSale", totalSale, false);

igRegisterScript("PivotDataFlatAggregateMinSale", totalMin, false);

igRegisterScript("PivotDataFlatAggregateMaxSale", totalMax, false);

igRegisterScript("OnValueInit", (args) => {
    const value = args.detail;
    if (value.member === "AmountOfSale") {
      value.aggregate.aggregator = totalSale;
      value.aggregateList?.forEach((aggr) => {
        switch (aggr.key) {
          case "SUM":
            aggr.aggregator = totalSale;
            break;
          case "MIN":
            aggr.aggregator = totalMin;
            break;
          case "MAX":
            aggr.aggregator = totalMax;
            break;
        }
      });
    }
}, false);

jsコピー

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

.horizontal {
    gap: 10px;
    flex-basis: fit-content;
    flex-wrap: wrap;
}

.sampleContainer {
    padding: 0.5rem
}cssコピー

Like this sample? Get access to our complete Ignite UI for Blazor toolkit and start building your own apps in minutes. Download it for free.

Limitations

• GetState method는 JSON.stringify() 메서드를 사용하여 원본 객체를 JSON 문자열로 변환합니다. JSON.stringify()는 함수를 지원하지 않기 때문에 지시문은 IgbGridState 피벗 차원 MemberFunction, 피벗 값 Member, Formatter 사용자 정의 Aggregate 함수 Styles 및 피벗 구성 전략을 ColumnStrategy​ ​RowStrategy 무시합니다.