Blazor Pivot Grid State Persistence
Blazor Pivot Grid의 Ignite UI for Blazor 상태 지속성을 통해 개발자는 그리드 상태를 쉽게 저장하고 복원할 수 있습니다. Blazor IgbGridState
IgbPivotGrid
에 적용되면 개발자가 모든 시나리오에서 상태 유지를 달성하는 데 사용할 수 있는 및 ApplyStateFromStringAsync
메서드가 노출 GetStateAsStringAsync
됩니다.
Supported Features
IgbGridState
지시문은 다음 기능의 상태 저장 및 복원을 지원합니다.
Sorting
Filtering
CellSelection
ColumnSelection
Expansion
PivotConfiguration
- Pivot Configuration properties defined by the
IPivotConfiguration
interface. - 피벗 차원 및 값 기능은 애플리케이션 수준 코드를 사용하여 복원됩니다. 피벗 구성 복원 섹션을 참조하세요.
- Pivot Configuration properties defined by the
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
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
});
}
}
csusing 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 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");
}
}
razorconst 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
무시합니다.