DevExtreme v25.1 is now available.

Explore our newest features/capabilities and share your thoughts with us.

Your search did not match any results.

Angular Pivot Grid - Standalone Field Chooser

DevExtreme includes a standalone PivotGridFieldChooser component. Unlike its integrated counterpart, the standalone field chooser can remain visible on the page at all times.

Backend API
<dx-pivot-grid [allowSortingBySummary]="true" [allowSorting]="true" [allowFiltering]="true" [showBorders]="true" [dataSource]="pivotGridDataSource" > <dxo-field-chooser [enabled]="false"></dxo-field-chooser> </dx-pivot-grid> <div class="container"> <dx-pivot-grid-field-chooser [dataSource]="pivotGridDataSource" [width]="400" [height]="400" [layout]="layout" [applyChangesMode]="applyChangesMode" [(state)]="state" > <dxo-texts allFields="All" columnFields="Columns" dataFields="Data" rowFields="Rows" filterFields="Filter" > </dxo-texts> </dx-pivot-grid-field-chooser> <div class="bottom-bar" *ngIf="applyChangesMode === 'onDemand'"> <dx-button id="applyButton" text="Apply" type="default" (onClick)="applyClick()" > </dx-button> <dx-button text="Cancel" (onClick)="cancelClick()"> </dx-button> </div> <div class="options"> <div class="caption">Options</div> <div class="option"> <span>Choose layout:</span> <dx-radio-group class="option-editor" id="layouts" [items]="layouts" layout="vertical" valueExpr="key" displayExpr="name" [(value)]="layout" > </dx-radio-group> </div> <div class="option"> <span>Apply Changes Mode:</span> <dx-select-box class="option-editor" [inputAttr]="{ 'aria-label': 'Apply Changes Mode' }" [items]="applyChangesModes" width="180" [(value)]="applyChangesMode" > </dx-select-box> </div> </div> </div>
import { NgModule, Component, enableProdMode } from '@angular/core'; import { BrowserModule } from '@angular/platform-browser'; import { platformBrowserDynamic } from '@angular/platform-browser-dynamic'; import { DxPivotGridFieldChooserModule, DxRadioGroupModule, DxButtonModule, DxSelectBoxModule, } from 'devextreme-angular'; import PivotGridDataSource from 'devextreme/ui/pivot_grid/data_source'; import { DxPivotGridModule, DxPivotGridTypes } from 'devextreme-angular/ui/pivot-grid'; import { Service, Layout, Sale } from './app.service'; if (!/localhost/.test(document.location.host)) { enableProdMode(); } let modulePrefix = ''; // @ts-ignore if (window && window.config?.packageConfigPaths) { modulePrefix = '/app'; } @Component({ selector: 'demo-app', templateUrl: `app/app.component.html`, styleUrls: [`app/app.component.css`], providers: [Service], preserveWhitespaces: true, }) export class AppComponent { pivotGridDataSource: PivotGridDataSource; layouts: Layout[]; layout = 0; applyChangesModes: DxPivotGridTypes.ApplyChangesMode[] = ['instantly', 'onDemand']; applyChangesMode = this.applyChangesModes[0]; state: Record<string, unknown>; constructor(service: Service) { this.pivotGridDataSource = new PivotGridDataSource({ fields: [{ caption: 'Region', width: 120, dataField: 'region', area: 'row', headerFilter: { search: { enabled: true, }, }, }, { caption: 'City', dataField: 'city', width: 150, area: 'row', headerFilter: { search: { enabled: true, }, }, selector(data: Sale) { return `${data.city} (${data.country})`; }, }, { dataField: 'date', dataType: 'date', area: 'column', }, { caption: 'Sales', dataField: 'amount', dataType: 'number', summaryType: 'sum', format: 'currency', area: 'data', }], store: service.getSales(), }); this.state = this.pivotGridDataSource.state(); this.layouts = service.getLayouts(); } applyClick() { this.pivotGridDataSource.state(this.state); } cancelClick() { this.state = this.pivotGridDataSource.state(); } } @NgModule({ imports: [ BrowserModule, DxPivotGridModule, DxRadioGroupModule, DxPivotGridFieldChooserModule, DxSelectBoxModule, DxButtonModule, ], declarations: [AppComponent], bootstrap: [AppComponent], }) export class AppModule { } platformBrowserDynamic().bootstrapModule(AppModule);
::ng-deep .container { position: relative; margin-top: 20px; } .options { padding: 20px; background-color: rgba(191, 191, 191, 0.15); position: absolute; top: 29px; bottom: 5px; left: 420px; width: 180px; } .caption { font-size: 18px; font-weight: 500; } .option { margin-top: 10px; } ::ng-deep .bottom-bar { width: 396px; text-align: right; margin-top: 5px; } ::ng-deep #applyButton { margin-right: 10px; } ::ng-deep .option-editor { margin-top: 5px; }
import { Injectable } from '@angular/core'; import type { DxPivotGridTypes } from 'devextreme-angular/ui/pivot-grid'; export class Sale { orderId: number; region: string; country: string; city: string; amount: number; date: string; } export class Layout { key: DxPivotGridTypes.FieldChooserLayout; name: string; } const sales: Sale[] = [{ orderId: 1, region: 'North America', country: 'USA', city: 'New York', amount: 1740, date: '2013/01/06', }, { orderId: 2, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 850, date: '2013/01/13', }, { orderId: 3, region: 'North America', country: 'USA', city: 'Denver', amount: 2235, date: '2013/01/07', }, { orderId: 4, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 1965, date: '2013/01/03', }, { orderId: 5, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 880, date: '2013/01/10', }, { orderId: 6, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 5260, date: '2013/01/17', }, { orderId: 7, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 2790, date: '2013/01/21', }, { orderId: 8, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 3140, date: '2013/01/01', }, { orderId: 9, region: 'Europe', country: 'GBR', city: 'London', amount: 6175, date: '2013/01/24', }, { orderId: 10, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 4575, date: '2013/01/11', }, { orderId: 11, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 3680, date: '2013/01/12', }, { orderId: 12, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 8400, date: '2013/01/05', }, { orderId: 13, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 1325, date: '2013/01/14', }, { orderId: 14, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 3920, date: '2013/01/05', }, { orderId: 15, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 2220, date: '2013/01/15', }, { orderId: 16, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 940, date: '2013/01/01', }, { orderId: 17, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 1630, date: '2013/01/10', }, { orderId: 18, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 2910, date: '2013/01/23', }, { orderId: 19, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 2600, date: '2013/01/14', }, { orderId: 20, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 4340, date: '2013/01/26', }, { orderId: 21, region: 'Europe', country: 'GBR', city: 'London', amount: 6650, date: '2013/01/24', }, { orderId: 22, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 490, date: '2013/01/22', }, { orderId: 23, region: 'North America', country: 'USA', city: 'New York', amount: 3390, date: '2013/01/25', }, { orderId: 24, region: 'North America', country: 'USA', city: 'New York', amount: 5160, date: '2013/02/20', }, { orderId: 25, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 5750, date: '2013/02/12', }, { orderId: 26, region: 'North America', country: 'USA', city: 'Denver', amount: 2805, date: '2013/02/13', }, { orderId: 27, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 2505, date: '2013/02/09', }, { orderId: 28, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 930, date: '2013/02/04', }, { orderId: 29, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 1240, date: '2013/02/03', }, { orderId: 30, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 315, date: '2013/02/04', }, { orderId: 31, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 2870, date: '2013/02/18', }, { orderId: 32, region: 'Europe', country: 'GBR', city: 'London', amount: 5150, date: '2013/02/18', }, { orderId: 33, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 2725, date: '2013/02/20', }, { orderId: 34, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 2840, date: '2013/02/04', }, { orderId: 35, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 1200, date: '2013/02/03', }, { orderId: 36, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 4550, date: '2013/02/08', }, { orderId: 37, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 6040, date: '2013/02/17', }, { orderId: 38, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 2205, date: '2013/02/08', }, { orderId: 39, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 990, date: '2013/02/20', }, { orderId: 40, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 700, date: '2013/02/11', }, { orderId: 41, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 2325, date: '2013/02/15', }, { orderId: 42, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 930, date: '2013/02/21', }, { orderId: 43, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 1560, date: '2013/02/04', }, { orderId: 44, region: 'North America', country: 'USA', city: 'New York', amount: 1740, date: '2013/03/04', }, { orderId: 45, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 3575, date: '2013/03/20', }, { orderId: 46, region: 'North America', country: 'USA', city: 'Denver', amount: 4500, date: '2013/03/04', }, { orderId: 47, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 1605, date: '2013/03/17', }, { orderId: 48, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 800, date: '2013/03/21', }, { orderId: 49, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 640, date: '2013/03/08', }, { orderId: 50, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 735, date: '2013/03/19', }, { orderId: 51, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 2520, date: '2013/03/20', }, { orderId: 52, region: 'Europe', country: 'GBR', city: 'London', amount: 6675, date: '2013/03/18', }, { orderId: 53, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 3625, date: '2013/03/25', }, { orderId: 54, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 1200, date: '2013/03/07', }, { orderId: 55, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 2700, date: '2013/03/19', }, { orderId: 56, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 5950, date: '2013/03/24', }, { orderId: 57, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 5120, date: '2013/03/08', }, { orderId: 58, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 1980, date: '2013/03/17', }, { orderId: 59, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 1110, date: '2013/03/08', }, { orderId: 60, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 980, date: '2013/03/21', }, { orderId: 61, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 5460, date: '2013/03/19', }, { orderId: 62, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 3800, date: '2013/03/12', }, { orderId: 63, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 2610, date: '2013/03/04', }, { orderId: 64, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 2010, date: '2013/03/23', }, { orderId: 65, region: 'North America', country: 'USA', city: 'New York', amount: 7680, date: '2013/04/15', }, { orderId: 66, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 1325, date: '2013/04/07', }, { orderId: 67, region: 'North America', country: 'USA', city: 'Denver', amount: 2835, date: '2013/04/10', }, { orderId: 68, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 3660, date: '2013/04/10', }, { orderId: 69, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 390, date: '2013/04/12', }, { orderId: 70, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 4420, date: '2013/04/08', }, { orderId: 71, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 1755, date: '2013/04/13', }, { orderId: 72, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 2580, date: '2013/04/15', }, { orderId: 73, region: 'Europe', country: 'GBR', city: 'London', amount: 850, date: '2013/04/01', }, { orderId: 74, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 2825, date: '2013/04/10', }, { orderId: 75, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 540, date: '2013/04/06', }, { orderId: 76, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 1110, date: '2013/04/16', }, { orderId: 77, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 6850, date: '2013/04/19', }, { orderId: 78, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 1940, date: '2013/04/23', }, { orderId: 79, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 1980, date: '2013/04/21', }, { orderId: 80, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 3090, date: '2013/04/03', }, { orderId: 81, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 1640, date: '2013/04/24', }, { orderId: 82, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 3585, date: '2013/04/01', }, { orderId: 83, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 1770, date: '2013/04/01', }, { orderId: 84, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 4005, date: '2013/04/04', }, { orderId: 85, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 2870, date: '2013/04/02', }, { orderId: 86, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 960, date: '2013/04/20', }, { orderId: 87, region: 'North America', country: 'USA', city: 'New York', amount: 8640, date: '2013/05/14', }, { orderId: 88, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 5450, date: '2013/05/24', }, { orderId: 89, region: 'North America', country: 'USA', city: 'Denver', amount: 2535, date: '2013/05/07', }, { orderId: 90, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 1155, date: '2013/05/20', }, { orderId: 91, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 3140, date: '2013/05/18', }, { orderId: 92, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 2260, date: '2013/05/19', }, { orderId: 93, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 1215, date: '2013/05/23', }, { orderId: 94, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 1210, date: '2013/05/08', }, { orderId: 95, region: 'Europe', country: 'GBR', city: 'London', amount: 875, date: '2013/05/25', }, { orderId: 96, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 5400, date: '2013/05/03', }, { orderId: 97, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 5940, date: '2013/05/25', }, { orderId: 98, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 9210, date: '2013/05/22', }, { orderId: 99, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 7950, date: '2013/05/12', }, { orderId: 100, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 3740, date: '2013/05/24', }, { orderId: 101, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 990, date: '2013/05/02', }, { orderId: 102, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 3190, date: '2013/05/03', }, { orderId: 103, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 2430, date: '2013/05/11', }, { orderId: 104, region: 'North America', country: 'USA', city: 'New York', amount: 7380, date: '2013/06/15', }, { orderId: 105, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 4475, date: '2013/06/08', }, { orderId: 106, region: 'North America', country: 'USA', city: 'Denver', amount: 1290, date: '2013/06/10', }, { orderId: 107, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 2250, date: '2013/06/10', }, { orderId: 108, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 350, date: '2013/06/22', }, { orderId: 109, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 5480, date: '2013/06/24', }, { orderId: 110, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 2355, date: '2013/06/10', }, { orderId: 111, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 1960, date: '2013/06/23', }, { orderId: 112, region: 'Europe', country: 'GBR', city: 'London', amount: 4125, date: '2013/06/06', }, { orderId: 113, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 7925, date: '2013/06/12', }, { orderId: 114, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 1120, date: '2013/06/22', }, { orderId: 115, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 5130, date: '2013/06/10', }, { orderId: 116, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 2475, date: '2013/06/10', }, { orderId: 117, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 2100, date: '2013/06/06', }, { orderId: 118, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 3570, date: '2013/06/10', }, { orderId: 119, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 550, date: '2013/06/02', }, { orderId: 120, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 2850, date: '2013/06/26', }, { orderId: 121, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 1460, date: '2013/06/17', }, { orderId: 122, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 960, date: '2013/06/17', }, { orderId: 123, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 1520, date: '2013/06/03', }, { orderId: 124, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 6750, date: '2013/06/21', }, { orderId: 125, region: 'North America', country: 'USA', city: 'New York', amount: 7260, date: '2013/07/14', }, { orderId: 126, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 2450, date: '2013/07/11', }, { orderId: 127, region: 'North America', country: 'USA', city: 'Denver', amount: 3540, date: '2013/07/02', }, { orderId: 128, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 1950, date: '2013/07/03', }, { orderId: 129, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 360, date: '2013/07/07', }, { orderId: 130, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 4500, date: '2013/07/03', }, { orderId: 131, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 4575, date: '2013/07/21', }, { orderId: 132, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 2310, date: '2013/07/18', }, { orderId: 133, region: 'Europe', country: 'GBR', city: 'London', amount: 7500, date: '2013/07/04', }, { orderId: 134, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 3575, date: '2013/07/23', }, { orderId: 135, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 760, date: '2013/07/01', }, { orderId: 136, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 3480, date: '2013/07/23', }, { orderId: 137, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 4875, date: '2013/07/11', }, { orderId: 138, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 4980, date: '2013/07/19', }, { orderId: 139, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 2580, date: '2013/07/04', }, { orderId: 140, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 2650, date: '2013/07/16', }, { orderId: 141, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 1190, date: '2013/07/02', }, { orderId: 142, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 960, date: '2013/07/26', }, { orderId: 143, region: 'North America', country: 'USA', city: 'New York', amount: 3600, date: '2013/08/08', }, { orderId: 144, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 2250, date: '2013/08/01', }, { orderId: 145, region: 'North America', country: 'USA', city: 'Denver', amount: 1275, date: '2013/08/02', }, { orderId: 146, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 3885, date: '2013/08/14', }, { orderId: 147, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 1900, date: '2013/08/05', }, { orderId: 148, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 2300, date: '2013/08/09', }, { orderId: 149, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 2895, date: '2013/08/15', }, { orderId: 150, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 350, date: '2013/08/20', }, { orderId: 151, region: 'Europe', country: 'GBR', city: 'London', amount: 4200, date: '2013/08/22', }, { orderId: 152, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 7175, date: '2013/08/14', }, { orderId: 153, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 4420, date: '2013/08/24', }, { orderId: 154, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 6990, date: '2013/08/22', }, { orderId: 155, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 2125, date: '2013/08/05', }, { orderId: 156, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 2220, date: '2013/08/16', }, { orderId: 157, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 1575, date: '2013/08/23', }, { orderId: 158, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 1880, date: '2013/08/12', }, { orderId: 159, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 710, date: '2013/08/25', }, { orderId: 160, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 390, date: '2013/08/20', }, { orderId: 161, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 4635, date: '2013/08/04', }, { orderId: 162, region: 'North America', country: 'USA', city: 'Denver', amount: 4350, date: '2013/08/19', }, { orderId: 163, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 6020, date: '2013/08/02', }, { orderId: 164, region: 'North America', country: 'USA', city: 'New York', amount: 3660, date: '2013/08/19', }, { orderId: 165, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 4525, date: '2013/08/24', }, { orderId: 166, region: 'North America', country: 'USA', city: 'New York', amount: 4410, date: '2013/09/12', }, { orderId: 167, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 1725, date: '2013/09/07', }, { orderId: 168, region: 'North America', country: 'USA', city: 'Denver', amount: 2715, date: '2013/09/14', }, { orderId: 169, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 2820, date: '2013/09/08', }, { orderId: 170, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 2310, date: '2013/09/12', }, { orderId: 171, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 780, date: '2013/09/08', }, { orderId: 172, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 2370, date: '2013/09/19', }, { orderId: 173, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 1410, date: '2013/09/09', }, { orderId: 174, region: 'Europe', country: 'GBR', city: 'London', amount: 1825, date: '2013/09/23', }, { orderId: 175, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 4075, date: '2013/09/06', }, { orderId: 176, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 1020, date: '2013/09/04', }, { orderId: 177, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 2820, date: '2013/09/08', }, { orderId: 178, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 3050, date: '2013/09/04', }, { orderId: 179, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 5080, date: '2013/09/25', }, { orderId: 180, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 1125, date: '2013/09/13', }, { orderId: 181, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 850, date: '2013/09/24', }, { orderId: 182, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 1440, date: '2013/09/19', }, { orderId: 183, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 1950, date: '2013/09/02', }, { orderId: 184, region: 'North America', country: 'USA', city: 'New York', amount: 6390, date: '2013/10/11', }, { orderId: 185, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 4625, date: '2013/10/02', }, { orderId: 186, region: 'North America', country: 'USA', city: 'Denver', amount: 3510, date: '2013/10/24', }, { orderId: 187, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 2730, date: '2013/10/15', }, { orderId: 188, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 2070, date: '2013/10/15', }, { orderId: 189, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 2320, date: '2013/10/18', }, { orderId: 190, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 4260, date: '2013/10/24', }, { orderId: 191, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 840, date: '2013/10/18', }, { orderId: 192, region: 'Europe', country: 'GBR', city: 'London', amount: 7300, date: '2013/10/24', }, { orderId: 193, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 5950, date: '2013/10/11', }, { orderId: 194, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 3220, date: '2013/10/25', }, { orderId: 195, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 4470, date: '2013/10/05', }, { orderId: 196, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 3675, date: '2013/10/23', }, { orderId: 197, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 4260, date: '2013/10/01', }, { orderId: 198, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 4245, date: '2013/10/26', }, { orderId: 199, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 1470, date: '2013/10/01', }, { orderId: 200, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 1810, date: '2013/10/02', }, { orderId: 201, region: 'North America', country: 'USA', city: 'New York', amount: 600, date: '2013/10/23', }, { orderId: 202, region: 'North America', country: 'USA', city: 'New York', amount: 7500, date: '2013/11/03', }, { orderId: 203, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 4625, date: '2013/11/02', }, { orderId: 204, region: 'North America', country: 'USA', city: 'Denver', amount: 2625, date: '2013/11/09', }, { orderId: 205, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 1440, date: '2013/11/15', }, { orderId: 206, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 2420, date: '2013/11/15', }, { orderId: 207, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 4180, date: '2013/11/15', }, { orderId: 208, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 3720, date: '2013/11/25', }, { orderId: 209, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 2730, date: '2013/11/08', }, { orderId: 210, region: 'Europe', country: 'GBR', city: 'London', amount: 3775, date: '2013/11/17', }, { orderId: 211, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 3525, date: '2013/11/15', }, { orderId: 212, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 5320, date: '2013/11/08', }, { orderId: 213, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 7050, date: '2013/11/14', }, { orderId: 214, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 4200, date: '2013/11/18', }, { orderId: 215, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 4960, date: '2013/11/04', }, { orderId: 216, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 2280, date: '2013/11/13', }, { orderId: 217, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 590, date: '2013/11/11', }, { orderId: 218, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 810, date: '2013/11/12', }, { orderId: 219, region: 'Europe', country: 'GBR', city: 'London', amount: 2625, date: '2013/11/07', }, { orderId: 220, region: 'North America', country: 'USA', city: 'New York', amount: 8280, date: '2013/12/01', }, { orderId: 221, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 5650, date: '2013/12/19', }, { orderId: 222, region: 'North America', country: 'USA', city: 'Denver', amount: 2760, date: '2013/12/14', }, { orderId: 223, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 2670, date: '2013/12/03', }, { orderId: 224, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 2520, date: '2013/12/20', }, { orderId: 225, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 4080, date: '2013/12/21', }, { orderId: 226, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 4140, date: '2013/12/22', }, { orderId: 227, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 390, date: '2013/12/04', }, { orderId: 228, region: 'Europe', country: 'GBR', city: 'London', amount: 1400, date: '2013/12/19', }, { orderId: 229, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 7275, date: '2013/12/22', }, { orderId: 230, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 4100, date: '2013/12/20', }, { orderId: 231, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 7290, date: '2013/12/05', }, { orderId: 232, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 625, date: '2013/12/22', }, { orderId: 233, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 4460, date: '2013/12/12', }, { orderId: 234, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 3825, date: '2013/12/13', }, { orderId: 235, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 2850, date: '2013/12/17', }, { orderId: 236, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 2780, date: '2013/12/07', }, { orderId: 237, region: 'North America', country: 'USA', city: 'New York', amount: 840, date: '2013/12/18', }, { orderId: 238, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 2970, date: '2013/12/23', }, { orderId: 239, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 945, date: '2013/12/06', }, { orderId: 240, region: 'North America', country: 'USA', city: 'Denver', amount: 2625, date: '2013/12/04', }, { orderId: 241, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 390, date: '2013/12/01', }, { orderId: 242, region: 'North America', country: 'USA', city: 'New York', amount: 7710, date: '2014/01/18', }, { orderId: 243, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 7975, date: '2014/01/10', }, { orderId: 244, region: 'North America', country: 'USA', city: 'Denver', amount: 3285, date: '2014/01/13', }, { orderId: 245, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 2580, date: '2014/01/22', }, { orderId: 246, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 2160, date: '2014/01/26', }, { orderId: 247, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 1100, date: '2014/01/25', }, { orderId: 248, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 4425, date: '2014/01/21', }, { orderId: 249, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 1360, date: '2014/01/22', }, { orderId: 250, region: 'Europe', country: 'GBR', city: 'London', amount: 3250, date: '2014/01/14', }, { orderId: 251, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 5550, date: '2014/01/21', }, { orderId: 252, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 2860, date: '2014/01/25', }, { orderId: 253, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 3450, date: '2014/01/24', }, { orderId: 254, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 5425, date: '2014/01/11', }, { orderId: 255, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 4860, date: '2014/01/12', }, { orderId: 256, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 4695, date: '2014/01/16', }, { orderId: 257, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 610, date: '2014/01/05', }, { orderId: 258, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 1580, date: '2014/01/15', }, { orderId: 259, region: 'North America', country: 'USA', city: 'New York', amount: 3780, date: '2014/02/18', }, { orderId: 260, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 5400, date: '2014/02/21', }, { orderId: 261, region: 'North America', country: 'USA', city: 'Denver', amount: 630, date: '2014/02/18', }, { orderId: 262, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 3960, date: '2014/02/04', }, { orderId: 263, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 2010, date: '2014/02/25', }, { orderId: 264, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 5000, date: '2014/02/01', }, { orderId: 265, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 1995, date: '2014/02/20', }, { orderId: 266, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 860, date: '2014/02/12', }, { orderId: 267, region: 'Europe', country: 'GBR', city: 'London', amount: 2150, date: '2014/02/10', }, { orderId: 268, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 4050, date: '2014/02/06', }, { orderId: 269, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 2960, date: '2014/02/18', }, { orderId: 270, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 3390, date: '2014/02/03', }, { orderId: 271, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 4425, date: '2014/02/15', }, { orderId: 272, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 1180, date: '2014/02/23', }, { orderId: 273, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 360, date: '2014/02/08', }, { orderId: 274, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 2310, date: '2014/02/13', }, { orderId: 275, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 1770, date: '2014/02/20', }, { orderId: 276, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 3060, date: '2014/02/26', }, { orderId: 277, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 1750, date: '2014/02/12', }, { orderId: 278, region: 'North America', country: 'USA', city: 'New York', amount: 2280, date: '2014/03/09', }, { orderId: 279, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 7600, date: '2014/03/25', }, { orderId: 280, region: 'North America', country: 'USA', city: 'Denver', amount: 1035, date: '2014/03/23', }, { orderId: 281, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 1245, date: '2014/03/01', }, { orderId: 282, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 2860, date: '2014/03/19', }, { orderId: 283, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 440, date: '2014/03/19', }, { orderId: 284, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 4665, date: '2014/03/02', }, { orderId: 285, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 2270, date: '2014/03/15', }, { orderId: 286, region: 'Europe', country: 'GBR', city: 'London', amount: 5000, date: '2014/03/09', }, { orderId: 287, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 5100, date: '2014/03/23', }, { orderId: 288, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 2120, date: '2014/03/11', }, { orderId: 289, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 9510, date: '2014/03/19', }, { orderId: 290, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 7600, date: '2014/03/21', }, { orderId: 291, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 5420, date: '2014/03/15', }, { orderId: 292, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 1980, date: '2014/03/05', }, { orderId: 293, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 1820, date: '2014/03/07', }, { orderId: 294, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 1670, date: '2014/03/21', }, { orderId: 295, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 4800, date: '2014/03/08', }, { orderId: 296, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 2925, date: '2014/03/03', }, { orderId: 297, region: 'North America', country: 'USA', city: 'New York', amount: 2940, date: '2014/04/11', }, { orderId: 298, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 3525, date: '2014/04/13', }, { orderId: 299, region: 'North America', country: 'USA', city: 'Denver', amount: 2475, date: '2014/04/22', }, { orderId: 300, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 3315, date: '2014/04/08', }, { orderId: 301, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 3140, date: '2014/04/07', }, { orderId: 302, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 2520, date: '2014/04/01', }, { orderId: 303, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 1200, date: '2014/04/10', }, { orderId: 304, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 2060, date: '2014/04/21', }, { orderId: 305, region: 'Europe', country: 'GBR', city: 'London', amount: 7875, date: '2014/04/02', }, { orderId: 306, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 1450, date: '2014/04/07', }, { orderId: 307, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 2640, date: '2014/04/22', }, { orderId: 308, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 4500, date: '2014/04/05', }, { orderId: 309, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 5050, date: '2014/04/11', }, { orderId: 310, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 2940, date: '2014/04/02', }, { orderId: 311, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 2880, date: '2014/04/14', }, { orderId: 312, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 1050, date: '2014/04/19', }, { orderId: 313, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 1850, date: '2014/04/02', }, { orderId: 314, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 3160, date: '2014/04/01', }, { orderId: 315, region: 'Europe', country: 'GBR', city: 'London', amount: 875, date: '2014/04/04', }, { orderId: 316, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 1380, date: '2014/04/21', }, { orderId: 317, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 3060, date: '2014/04/06', }, { orderId: 318, region: 'North America', country: 'USA', city: 'New York', amount: 6690, date: '2014/05/19', }, { orderId: 319, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 4525, date: '2014/05/15', }, { orderId: 320, region: 'North America', country: 'USA', city: 'Denver', amount: 4665, date: '2014/05/10', }, { orderId: 321, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 4530, date: '2014/05/18', }, { orderId: 322, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 1330, date: '2014/05/08', }, { orderId: 323, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 1720, date: '2014/05/20', }, { orderId: 324, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 3750, date: '2014/05/16', }, { orderId: 325, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 1290, date: '2014/05/10', }, { orderId: 326, region: 'Europe', country: 'GBR', city: 'London', amount: 4925, date: '2014/05/14', }, { orderId: 327, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 4300, date: '2014/05/22', }, { orderId: 328, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 5740, date: '2014/05/08', }, { orderId: 329, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 1440, date: '2014/05/21', }, { orderId: 330, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 5975, date: '2014/05/25', }, { orderId: 331, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 4440, date: '2014/05/05', }, { orderId: 332, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 2310, date: '2014/05/24', }, { orderId: 333, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 2250, date: '2014/05/06', }, { orderId: 334, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 2320, date: '2014/05/14', }, { orderId: 335, region: 'North America', country: 'USA', city: 'New York', amount: 5190, date: '2014/06/26', }, { orderId: 336, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 925, date: '2014/06/04', }, { orderId: 337, region: 'North America', country: 'USA', city: 'Denver', amount: 3240, date: '2014/06/20', }, { orderId: 338, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 3180, date: '2014/06/23', }, { orderId: 339, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 780, date: '2014/06/13', }, { orderId: 340, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 4680, date: '2014/06/08', }, { orderId: 341, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 2475, date: '2014/06/25', }, { orderId: 342, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 1920, date: '2014/06/20', }, { orderId: 343, region: 'Europe', country: 'GBR', city: 'London', amount: 7500, date: '2014/06/25', }, { orderId: 344, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 5025, date: '2014/06/26', }, { orderId: 345, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 2400, date: '2014/06/08', }, { orderId: 346, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 5430, date: '2014/06/03', }, { orderId: 347, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 4475, date: '2014/06/19', }, { orderId: 348, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 1420, date: '2014/06/20', }, { orderId: 349, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 2670, date: '2014/06/25', }, { orderId: 350, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 1930, date: '2014/06/02', }, { orderId: 351, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 580, date: '2014/06/25', }, { orderId: 352, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 1620, date: '2014/06/12', }, { orderId: 353, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 4530, date: '2014/06/02', }, { orderId: 354, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 6025, date: '2014/06/23', }, { orderId: 355, region: 'North America', country: 'USA', city: 'New York', amount: 3540, date: '2014/07/21', }, { orderId: 356, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 3000, date: '2014/07/01', }, { orderId: 357, region: 'North America', country: 'USA', city: 'Denver', amount: 3240, date: '2014/07/26', }, { orderId: 358, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 2265, date: '2014/07/22', }, { orderId: 359, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 400, date: '2014/07/09', }, { orderId: 360, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 1460, date: '2014/07/08', }, { orderId: 361, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 1620, date: '2014/07/18', }, { orderId: 362, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 2400, date: '2014/07/25', }, { orderId: 363, region: 'Europe', country: 'GBR', city: 'London', amount: 5275, date: '2014/07/04', }, { orderId: 364, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 4475, date: '2014/07/03', }, { orderId: 365, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 3980, date: '2014/07/21', }, { orderId: 366, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 5700, date: '2014/07/18', }, { orderId: 367, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 5575, date: '2014/07/01', }, { orderId: 368, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 2160, date: '2014/07/02', }, { orderId: 369, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 960, date: '2014/07/09', }, { orderId: 370, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 1280, date: '2014/07/04', }, { orderId: 371, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 1040, date: '2014/07/02', }, { orderId: 372, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 1760, date: '2014/07/25', }, { orderId: 373, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 4080, date: '2014/07/07', }, { orderId: 374, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 1000, date: '2014/07/21', }, { orderId: 375, region: 'North America', country: 'USA', city: 'New York', amount: 1770, date: '2014/08/23', }, { orderId: 376, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 2700, date: '2014/08/09', }, { orderId: 377, region: 'North America', country: 'USA', city: 'Denver', amount: 2175, date: '2014/08/03', }, { orderId: 378, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 3375, date: '2014/08/11', }, { orderId: 379, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 2040, date: '2014/08/01', }, { orderId: 380, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 3000, date: '2014/08/21', }, { orderId: 381, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 3900, date: '2014/08/16', }, { orderId: 382, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 1370, date: '2014/08/20', }, { orderId: 383, region: 'Europe', country: 'GBR', city: 'London', amount: 5700, date: '2014/08/01', }, { orderId: 384, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 1275, date: '2014/08/22', }, { orderId: 385, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 4060, date: '2014/08/13', }, { orderId: 386, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 4560, date: '2014/08/20', }, { orderId: 387, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 7575, date: '2014/08/20', }, { orderId: 388, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 700, date: '2014/08/25', }, { orderId: 389, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 2400, date: '2014/08/16', }, { orderId: 390, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 1390, date: '2014/08/15', }, { orderId: 391, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 1320, date: '2014/08/09', }, { orderId: 392, region: 'North America', country: 'USA', city: 'Denver', amount: 1680, date: '2014/08/09', }, { orderId: 393, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 1500, date: '2014/08/11', }, { orderId: 394, region: 'North America', country: 'USA', city: 'New York', amount: 6150, date: '2014/09/21', }, { orderId: 395, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 3675, date: '2014/09/02', }, { orderId: 396, region: 'North America', country: 'USA', city: 'Denver', amount: 2250, date: '2014/09/05', }, { orderId: 397, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 3585, date: '2014/09/10', }, { orderId: 398, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 1470, date: '2014/09/01', }, { orderId: 399, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 2260, date: '2014/09/02', }, { orderId: 400, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 3765, date: '2014/09/03', }, { orderId: 401, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 1640, date: '2014/09/04', }, { orderId: 402, region: 'Europe', country: 'GBR', city: 'London', amount: 4475, date: '2014/09/09', }, { orderId: 403, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 5975, date: '2014/09/04', }, { orderId: 404, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 1100, date: '2014/09/16', }, { orderId: 405, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 9210, date: '2014/09/09', }, { orderId: 406, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 3700, date: '2014/09/01', }, { orderId: 407, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 3620, date: '2014/09/19', }, { orderId: 408, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 4275, date: '2014/09/01', }, { orderId: 409, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 2370, date: '2014/09/03', }, { orderId: 410, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 1870, date: '2014/09/10', }, { orderId: 411, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 2070, date: '2014/09/25', }, { orderId: 412, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 5025, date: '2014/09/19', }, { orderId: 413, region: 'North America', country: 'USA', city: 'New York', amount: 1080, date: '2014/10/15', }, { orderId: 414, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 1400, date: '2014/10/22', }, { orderId: 415, region: 'North America', country: 'USA', city: 'Denver', amount: 4260, date: '2014/10/01', }, { orderId: 416, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 2745, date: '2014/10/01', }, { orderId: 417, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 2920, date: '2014/10/23', }, { orderId: 418, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 3520, date: '2014/10/11', }, { orderId: 419, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 4035, date: '2014/10/20', }, { orderId: 420, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 1730, date: '2014/10/05', }, { orderId: 421, region: 'Europe', country: 'GBR', city: 'London', amount: 975, date: '2014/10/06', }, { orderId: 422, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 5700, date: '2014/10/06', }, { orderId: 423, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 5080, date: '2014/10/18', }, { orderId: 424, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 1230, date: '2014/10/11', }, { orderId: 425, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 600, date: '2014/10/08', }, { orderId: 426, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 3700, date: '2014/10/08', }, { orderId: 427, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 3375, date: '2014/10/11', }, { orderId: 428, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 1500, date: '2014/10/17', }, { orderId: 429, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 370, date: '2014/10/05', }, { orderId: 430, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 2340, date: '2014/10/16', }, { orderId: 431, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 1080, date: '2014/10/08', }, { orderId: 432, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 2775, date: '2014/10/21', }, { orderId: 433, region: 'North America', country: 'USA', city: 'New York', amount: 4380, date: '2014/11/09', }, { orderId: 434, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 5500, date: '2014/11/21', }, { orderId: 435, region: 'North America', country: 'USA', city: 'Denver', amount: 1920, date: '2014/11/24', }, { orderId: 436, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 765, date: '2014/11/24', }, { orderId: 437, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 370, date: '2014/11/18', }, { orderId: 438, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 3500, date: '2014/11/25', }, { orderId: 439, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 825, date: '2014/11/09', }, { orderId: 440, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 490, date: '2014/11/23', }, { orderId: 441, region: 'Europe', country: 'GBR', city: 'London', amount: 7075, date: '2014/11/20', }, { orderId: 442, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 1350, date: '2014/11/25', }, { orderId: 443, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 1440, date: '2014/11/15', }, { orderId: 444, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 1110, date: '2014/11/03', }, { orderId: 445, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 1150, date: '2014/11/23', }, { orderId: 446, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 2040, date: '2014/11/20', }, { orderId: 447, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 3090, date: '2014/11/24', }, { orderId: 448, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 1940, date: '2014/11/24', }, { orderId: 449, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 3090, date: '2014/11/16', }, { orderId: 450, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 4900, date: '2014/11/05', }, { orderId: 451, region: 'North America', country: 'USA', city: 'Denver', amount: 3465, date: '2014/11/07', }, { orderId: 452, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 1110, date: '2014/11/20', }, { orderId: 453, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 1650, date: '2014/11/02', }, { orderId: 454, region: 'North America', country: 'USA', city: 'New York', amount: 5280, date: '2014/12/04', }, { orderId: 455, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 3075, date: '2014/12/02', }, { orderId: 456, region: 'North America', country: 'USA', city: 'Denver', amount: 690, date: '2014/12/07', }, { orderId: 457, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 1305, date: '2014/12/15', }, { orderId: 458, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 1970, date: '2014/12/01', }, { orderId: 459, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 3760, date: '2014/12/18', }, { orderId: 460, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 1920, date: '2014/12/22', }, { orderId: 461, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 1360, date: '2014/12/12', }, { orderId: 462, region: 'Europe', country: 'GBR', city: 'London', amount: 2525, date: '2014/12/06', }, { orderId: 463, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 5575, date: '2014/12/20', }, { orderId: 464, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 5560, date: '2014/12/10', }, { orderId: 465, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 2820, date: '2014/12/10', }, { orderId: 466, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 4000, date: '2014/12/12', }, { orderId: 467, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 5820, date: '2014/12/02', }, { orderId: 468, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 1275, date: '2014/12/12', }, { orderId: 469, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 1310, date: '2014/12/01', }, { orderId: 470, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 2180, date: '2014/12/26', }, { orderId: 471, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 4470, date: '2014/12/17', }, { orderId: 472, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 2990, date: '2014/12/15', }, { orderId: 473, region: 'Europe', country: 'GBR', city: 'London', amount: 7650, date: '2014/12/18', }, { orderId: 474, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 780, date: '2014/12/02', }, { orderId: 475, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 2970, date: '2014/12/13', }, { orderId: 476, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 1155, date: '2014/12/05', }, { orderId: 477, region: 'North America', country: 'USA', city: 'New York', amount: 4470, date: '2015/01/10', }, { orderId: 478, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 1125, date: '2015/01/21', }, { orderId: 479, region: 'North America', country: 'USA', city: 'Denver', amount: 645, date: '2015/01/17', }, { orderId: 480, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 675, date: '2015/01/05', }, { orderId: 481, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 2840, date: '2015/01/05', }, { orderId: 482, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 2660, date: '2015/01/04', }, { orderId: 483, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 4560, date: '2015/01/12', }, { orderId: 484, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 2880, date: '2015/01/20', }, { orderId: 485, region: 'Europe', country: 'GBR', city: 'London', amount: 500, date: '2015/01/02', }, { orderId: 486, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 3925, date: '2015/01/07', }, { orderId: 487, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 5660, date: '2015/01/18', }, { orderId: 488, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 4830, date: '2015/01/13', }, { orderId: 489, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 3075, date: '2015/01/22', }, { orderId: 490, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 3120, date: '2015/01/14', }, { orderId: 491, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 3525, date: '2015/01/23', }, { orderId: 492, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 1930, date: '2015/01/09', }, { orderId: 493, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 2890, date: '2015/01/02', }, { orderId: 494, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 1545, date: '2015/01/17', }, { orderId: 495, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 3630, date: '2015/01/20', }, { orderId: 496, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 4035, date: '2015/01/14', }, { orderId: 497, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 345, date: '2015/01/06', }, { orderId: 498, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 7000, date: '2015/01/07', }, { orderId: 499, region: 'North America', country: 'USA', city: 'New York', amount: 3060, date: '2015/02/13', }, { orderId: 500, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 6425, date: '2015/02/04', }, { orderId: 501, region: 'North America', country: 'USA', city: 'Denver', amount: 615, date: '2015/02/22', }, { orderId: 502, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 1755, date: '2015/02/07', }, { orderId: 503, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 1540, date: '2015/02/21', }, { orderId: 504, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 2820, date: '2015/02/24', }, { orderId: 505, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 4305, date: '2015/02/10', }, { orderId: 506, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 1520, date: '2015/02/26', }, { orderId: 507, region: 'Europe', country: 'GBR', city: 'London', amount: 4725, date: '2015/02/18', }, { orderId: 508, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 6750, date: '2015/02/16', }, { orderId: 509, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 5540, date: '2015/02/07', }, { orderId: 510, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 9300, date: '2015/02/03', }, { orderId: 511, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 3700, date: '2015/02/26', }, { orderId: 512, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 740, date: '2015/02/01', }, { orderId: 513, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 4755, date: '2015/02/23', }, { orderId: 514, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 2570, date: '2015/02/20', }, { orderId: 515, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 2860, date: '2015/02/19', }, { orderId: 516, region: 'North America', country: 'USA', city: 'New York', amount: 5430, date: '2015/03/21', }, { orderId: 517, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 4525, date: '2015/03/21', }, { orderId: 518, region: 'North America', country: 'USA', city: 'Denver', amount: 1515, date: '2015/03/10', }, { orderId: 519, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 630, date: '2015/03/15', }, { orderId: 520, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 1310, date: '2015/03/01', }, { orderId: 521, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 3200, date: '2015/03/17', }, { orderId: 522, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 3945, date: '2015/03/20', }, { orderId: 523, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 2990, date: '2015/03/18', }, { orderId: 524, region: 'Europe', country: 'GBR', city: 'London', amount: 1125, date: '2015/03/22', }, { orderId: 525, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 7950, date: '2015/03/17', }, { orderId: 526, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 2960, date: '2015/03/25', }, { orderId: 527, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 3930, date: '2015/03/23', }, { orderId: 528, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 6975, date: '2015/03/02', }, { orderId: 529, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 4220, date: '2015/03/17', }, { orderId: 530, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 3090, date: '2015/03/25', }, { orderId: 531, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 2380, date: '2015/03/01', }, { orderId: 532, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 1510, date: '2015/03/07', }, { orderId: 533, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 1020, date: '2015/03/19', }, { orderId: 534, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 6700, date: '2015/03/26', }, { orderId: 535, region: 'North America', country: 'USA', city: 'New York', amount: 4890, date: '2015/04/02', }, { orderId: 536, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 7225, date: '2015/04/13', }, { orderId: 537, region: 'North America', country: 'USA', city: 'Denver', amount: 795, date: '2015/04/07', }, { orderId: 538, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 1785, date: '2015/04/03', }, { orderId: 539, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 1850, date: '2015/04/03', }, { orderId: 540, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 5120, date: '2015/04/12', }, { orderId: 541, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 615, date: '2015/04/07', }, { orderId: 542, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 2860, date: '2015/04/05', }, { orderId: 543, region: 'Europe', country: 'GBR', city: 'London', amount: 1525, date: '2015/04/24', }, { orderId: 544, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 7425, date: '2015/04/15', }, { orderId: 545, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 6080, date: '2015/04/13', }, { orderId: 546, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 9390, date: '2015/04/19', }, { orderId: 547, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 3200, date: '2015/04/26', }, { orderId: 548, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 4380, date: '2015/04/05', }, { orderId: 549, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 4725, date: '2015/04/06', }, { orderId: 550, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 930, date: '2015/04/25', }, { orderId: 551, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 1910, date: '2015/04/05', }, { orderId: 552, region: 'Europe', country: 'GBR', city: 'London', amount: 2725, date: '2015/04/16', }, { orderId: 553, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 4720, date: '2015/04/02', }, { orderId: 554, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 2800, date: '2015/04/26', }, { orderId: 555, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 3780, date: '2015/04/24', }, { orderId: 556, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 2340, date: '2015/04/17', }, { orderId: 557, region: 'North America', country: 'USA', city: 'New York', amount: 4830, date: '2015/05/12', }, { orderId: 558, region: 'North America', country: 'USA', city: 'Los Angeles', amount: 2075, date: '2015/05/23', }, { orderId: 559, region: 'North America', country: 'USA', city: 'Denver', amount: 3420, date: '2015/05/21', }, { orderId: 560, region: 'North America', country: 'CAN', city: 'Vancouver', amount: 1440, date: '2015/05/10', }, { orderId: 561, region: 'North America', country: 'CAN', city: 'Edmonton', amount: 1680, date: '2015/05/15', }, { orderId: 562, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', amount: 3440, date: '2015/05/16', }, { orderId: 563, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 4695, date: '2015/05/10', }, { orderId: 564, region: 'South America', country: 'PRY', city: 'Asuncion', amount: 2380, date: '2015/05/06', }, { orderId: 565, region: 'Europe', country: 'GBR', city: 'London', amount: 1875, date: '2015/05/25', }, { orderId: 566, region: 'Europe', country: 'DEU', city: 'Berlin', amount: 7550, date: '2015/05/14', }, { orderId: 567, region: 'Europe', country: 'ESP', city: 'Madrid', amount: 3340, date: '2015/05/01', }, { orderId: 568, region: 'Asia', country: 'JPN', city: 'Tokyo', amount: 8370, date: '2015/05/13', }, { orderId: 569, region: 'Asia', country: 'KOR', city: 'Seoul', amount: 3550, date: '2015/05/26', }, { orderId: 570, region: 'Australia', country: 'AUS', city: 'Sydney', amount: 2620, date: '2015/05/17', }, { orderId: 571, region: 'Australia', country: 'AUS', city: 'Melbourne', amount: 2400, date: '2015/05/21', }, { orderId: 572, region: 'Africa', country: 'ZAF', city: 'Pretoria', amount: 1740, date: '2015/05/21', }, { orderId: 573, region: 'Africa', country: 'EGY', city: 'Cairo', amount: 500, date: '2015/05/26', }, { orderId: 574, region: 'South America', country: 'ARG', city: 'Buenos Aires', amount: 780, date: '2015/05/07', }]; const layouts:Layout[] = [{ key: 0, name: 'Layout0', }, { key: 1, name: 'Layout1', }, { key: 2, name: 'Layout2', }]; @Injectable() export class Service { getSales() { return sales; } getLayouts() { return layouts; } }
// In real applications, you should not transpile code in the browser. // You can see how to create your own application with Angular and DevExtreme here: // https://js.devexpress.com/Documentation/Guide/Angular_Components/Getting_Started/Create_a_DevExtreme_Application/ const componentNames = [ 'accordion', 'action-sheet', 'autocomplete', 'bar-gauge', 'box', 'bullet', 'button-group', 'button', 'calendar', 'card-view', 'chart', 'chat', 'check-box', 'circular-gauge', 'color-box', 'context-menu', 'data-grid', 'date-box', 'date-range-box', 'defer-rendering', 'diagram', 'draggable', 'drawer', 'drop-down-box', 'drop-down-button', 'file-manager', 'file-uploader', 'filter-builder', 'form', 'funnel', 'gallery', 'gantt', 'html-editor', 'linear-gauge', 'list', 'load-indicator', 'load-panel', 'lookup', 'map', 'menu', 'multi-view', 'nested', 'number-box', 'pagination', 'pie-chart', 'pivot-grid-field-chooser', 'pivot-grid', 'polar-chart', 'popover', 'popup', 'progress-bar', 'radio-group', 'range-selector', 'range-slider', 'recurrence-editor', 'resizable', 'responsive-box', 'sankey', 'scheduler', 'scroll-view', 'select-box', 'slider', 'sortable', 'sparkline', 'speed-dial-action', 'splitter', 'stepper', 'switch', 'tab-panel', 'tabs', 'tag-box', 'text-area', 'text-box', 'tile-view', 'toast', 'toolbar', 'tooltip', 'tree-list', 'tree-map', 'tree-view', 'validation-group', 'validation-summary', 'validator', 'vector-map', ]; window.exports = window.exports || {}; window.config = { transpiler: 'ts', typescriptOptions: { module: 'system', emitDecoratorMetadata: true, experimentalDecorators: true, }, meta: { 'typescript': { 'exports': 'ts', }, 'devextreme/time_zone_utils.js': { 'esModule': true, }, 'devextreme/localization.js': { 'esModule': true, }, 'devextreme/viz/palette.js': { 'esModule': true, }, '@angular/platform-browser-dynamic': { 'esModule': true, }, '@angular/platform-browser': { 'esModule': true, }, '@angular/core': { 'esModule': true, }, '@angular/common': { 'esModule': true, }, '@angular/common/http': { 'esModule': true, }, '@angular/animations': { 'esModule': true, }, '@angular/forms': { 'esModule': true, }, 'openai': { 'esModule': true, }, }, paths: { 'npm:': 'https://cdn.jsdelivr.net/npm/', 'bundles:': '../../../../bundles/', 'externals:': '../../../../bundles/externals/', }, map: { 'ts': 'npm:plugin-typescript@8.0.0/lib/plugin.js', 'typescript': 'npm:typescript@4.2.4/lib/typescript.js', 'jszip': 'npm:jszip@3.10.1/dist/jszip.min.js', /* @angular */ '@angular/compiler': 'bundles:@angular/compiler.umd.js', '@angular/platform-browser-dynamic': 'bundles:@angular/platform-browser-dynamic.umd.js', '@angular/core': 'bundles:@angular/core.umd.js', '@angular/core/primitives/signals': 'bundles:@angular/core.primitives.signals.umd.js', '@angular/common': 'bundles:@angular/common.umd.js', '@angular/common/http': 'bundles:@angular/common-http.umd.js', '@angular/platform-browser': 'bundles:@angular/platform-browser.umd.js', '@angular/platform-browser/animations': 'bundles:@angular/platform-browser.umd.js', '@angular/forms': 'bundles:@angular/forms.umd.js', /* devextreme */ 'devextreme': 'npm:devextreme@link:../../packages/devextreme/artifacts/npm/devextreme/cjs', 'devextreme-quill': 'npm:devextreme-quill@1.7.5/dist/dx-quill.min.js', 'devexpress-diagram': 'npm:devexpress-diagram@2.2.24', 'devexpress-gantt': 'npm:devexpress-gantt@4.1.64', /* devextreme-angular umd maps */ 'devextreme-angular': 'bundles:devextreme-angular/devextreme-angular.umd.js', 'devextreme-angular/common/ai-integration': 'bundles:devextreme-angular/devextreme-angular-common-ai-integration.umd.js', 'devextreme-angular/core': 'bundles:devextreme-angular/devextreme-angular-core.umd.js', 'devextreme-angular/common/charts': 'bundles:devextreme-angular/devextreme-angular-common-charts.umd.js', 'devextreme-angular/common/core/animation': 'bundles:devextreme-angular/devextreme-angular-common-core-animation.umd.js', 'devextreme-angular/common/core/environment': 'bundles:devextreme-angular/devextreme-angular-common-core-environment.umd.js', 'devextreme-angular/common/core/events': 'bundles:devextreme-angular/devextreme-angular-common-core-events.umd.js', 'devextreme-angular/common/core/localization': 'bundles:devextreme-angular/devextreme-angular-common-core-localization.umd.js', 'devextreme-angular/common/core': 'bundles:devextreme-angular/devextreme-angular-common-core.umd.js', 'devextreme-angular/common/data/custom-store': 'bundles:devextreme-angular/devextreme-angular-common-data-custom-store.umd.js', 'devextreme-angular/common/data': 'bundles:devextreme-angular/devextreme-angular-common-data.umd.js', 'devextreme-angular/common/export/excel': 'bundles:devextreme-angular/devextreme-angular-common-export-excel.umd.js', 'devextreme-angular/common/export/pdf': 'bundles:devextreme-angular/devextreme-angular-common-export-pdf.umd.js', 'devextreme-angular/common/export': 'bundles:devextreme-angular/devextreme-angular-common-export.umd.js', 'devextreme-angular/common/grids': 'bundles:devextreme-angular/devextreme-angular-common-grids.umd.js', 'devextreme-angular/common': 'bundles:devextreme-angular/devextreme-angular-common.umd.js', 'devextreme-angular/http': 'bundles:devextreme-angular/devextreme-angular-http.umd.js', ...componentNames.reduce((acc, name) => { acc[`devextreme-angular/ui/${name}`] = `bundles:devextreme-angular/devextreme-angular-ui-${name}.umd.js`; acc[`devextreme-angular/ui/${name}/nested`] = `bundles:devextreme-angular/devextreme-angular-ui-${name}-nested.umd.js`; return acc; }, {}), 'tslib': 'npm:tslib/tslib.js', 'rxjs': 'npm:rxjs@7.5.3/dist/bundles/rxjs.umd.js', 'rxjs/operators': 'npm:rxjs@7.5.3/dist/cjs/operators/index.js', 'rrule': 'npm:rrule@2.6.4/dist/es5/rrule.js', 'luxon': 'npm:luxon@3.4.4/build/global/luxon.min.js', 'es6-object-assign': 'npm:es6-object-assign', 'inferno': 'npm:inferno@8.2.3/dist/inferno.min.js', 'inferno-compat': 'npm:inferno-compat/dist/inferno-compat.min.js', 'inferno-create-element': 'npm:inferno-create-element@8.2.3/dist/inferno-create-element.min.js', 'inferno-dom': 'npm:inferno-dom/dist/inferno-dom.min.js', 'inferno-hydrate': 'npm:inferno-hydrate/dist/inferno-hydrate.min.js', 'inferno-clone-vnode': 'npm:inferno-clone-vnode/dist/inferno-clone-vnode.min.js', 'inferno-create-class': 'npm:inferno-create-class/dist/inferno-create-class.min.js', 'inferno-extras': 'npm:inferno-extras/dist/inferno-extras.min.js', '@preact/signals-core': 'npm:@preact/signals-core@1.8.0/dist/signals-core.min.js', // Prettier 'prettier/standalone': 'npm:prettier@2.8.8/standalone.js', 'prettier/parser-html': 'npm:prettier@2.8.8/parser-html.js', }, packages: { 'app': { main: './app.component.ts', defaultExtension: 'ts', }, 'devextreme': { defaultExtension: 'js', }, 'devextreme/events/utils': { main: 'index', }, 'devextreme/common/core/events/utils': { main: 'index', }, 'devextreme/events': { main: 'index', }, 'es6-object-assign': { main: './index.js', defaultExtension: 'js', }, 'rxjs': { defaultExtension: 'js', }, 'rxjs/operators': { defaultExtension: 'js', }, }, packageConfigPaths: [ 'npm:@devextreme/*/package.json', 'npm:rxjs@7.5.3/package.json', 'npm:rxjs@7.5.3/operators/package.json', 'npm:devexpress-diagram@2.2.24/package.json', 'npm:devexpress-gantt@4.1.64/package.json', ], }; System.config(window.config); // System.import('@angular/compiler').catch(console.error.bind(console)); // eslint-disable-next-line const useTgzInCSB = ['openai']; let packagesInfo = { "@angular/core": { "version": "17.3.12" }, "core-js": { "version": "2.6.12" }, "typescript": { "version": "5.4.5" }, "zone.js": { "version": "0.14.10" } };
<!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml" lang="en"> <head> <title>DevExtreme Demo</title> <meta http-equiv="X-UA-Compatible" content="IE=edge" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=5.0" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/25.1.5/css/dx.light.css" /> <script src="https://cdn.jsdelivr.net/npm/core-js@2.6.12/client/shim.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/zone.js@0.14.10/bundles/zone.umd.js"></script> <script src="https://cdn.jsdelivr.net/npm/reflect-metadata@0.1.13/Reflect.js"></script> <script src="https://cdn.jsdelivr.net/npm/systemjs@0.21.3/dist/system.js"></script> <script src="config.js"></script> <script> System.import("app").catch(console.error.bind(console)); </script> </head> <body class="dx-viewport"> <div class="demo-container"> <demo-app>Loading...</demo-app> </div> </body> </html>

Follow the steps below to connect the PivotGridFieldChooser with the PivotGrid:

  1. Bind both components to the same data source
    Assign the same PivotGridDataSource instance to the dataSource property of both components.

  2. (Optional) Disable the integrated field chooser
    Both field choosers can work simultaneously, but if you want to disable the integrated version, set the PivotGrid's fieldChooser.enabled property to false.

  3. (Optional) Apply field changes on demand
    When users move fields within the field chooser, the changes are applied to the connected PivotGrid instantly. To change this behavior, set the applyChangesMode to "onDemand". In this mode, the changes are applied/canceled only when you call the applyChanges()/cancelChanges() method or set a new state. You can add a UI for these methods. For example, in this demo, they are bound to the Apply and Cancel buttons. Select "onDemand" from the Apply Changes Mode drop-down menu to display these buttons.

The standalone and integrated field choosers share features. For example, both field choosers include three layouts. You can use the radio buttons to switch between field choosers and review the differences. For information about other available features, refer to the Integrated Field Chooser demo.