DevExtreme v24.1 is now available.

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

Your search did not match any results.

Vue Pivot Grid - Field Panel

A field panel is an element that displays pivot grid fields involved in summary calculation. This panel consists of four field areas: column, row, data, and filter. Users can drag and drop fields between these areas, similar to the field chooser. You can use the field panel and the field chooser simultaneously, as shown in this demo.

Enable the fieldPanel.visible property to display the field panel. If you want to hide fields from specific areas, disable the corresponding properties in the fieldPanel object:

Backend API
<template> <div> <DxPivotGrid id="sales" :allow-sorting-by-summary="true" :allow-sorting="true" :allow-filtering="true" :height="490" :show-borders="true" :data-source="gridDataSource" :on-context-menu-preparing="onContextMenuPreparing" > <DxFieldChooser :height="500"/> <DxFieldPanel :show-column-fields="showColumnFields" :show-data-fields="showDataFields" :show-filter-fields="showFilterFields" :show-row-fields="showRowFields" :allow-field-dragging="true" :visible="true" /> </DxPivotGrid> <div class="options"> <div class="caption">Options</div> <div class="option"> <DxCheckBox id="show-data-fields" :value="true" :on-value-changed="OnShowColumnFieldsChanged" text="Show Data Fields" /> </div> {{ ' ' }} <div class="option"> <DxCheckBox id="show-row-fields" :value="true" :on-value-changed="OnShowDataFieldsChanged" text="Show Row Fields" /> </div> {{ ' ' }} <div class="option"> <DxCheckBox id="show-column-fields" :value="true" :on-value-changed="OnShowFilterFieldsChanged" text="Show Column Fields" /> </div> {{ ' ' }} <div class="option"> <DxCheckBox id="show-filter-fields" :value="true" :on-value-changed="OnShowRowFieldsChanged" text="Show Filter Fields" /> </div> </div> </div> </template> <script setup lang="ts"> import { ref } from 'vue'; import DxPivotGrid, { DxFieldChooser, DxFieldPanel, } from 'devextreme-vue/pivot-grid'; import DxCheckBox from 'devextreme-vue/check-box'; import PivotGridDataSource from 'devextreme/ui/pivot_grid/data_source'; import sales from './data.ts'; const showColumnFields = ref(true); const showDataFields = ref(true); const showFilterFields = ref(true); const showRowFields = ref(true); const gridDataSource = new PivotGridDataSource({ fields: [{ caption: 'Region', width: 120, dataField: 'region', area: 'row', }, { caption: 'City', dataField: 'city', width: 150, area: 'row', selector(data) { return `${data.city} (${data.country})`; }, }, { dataField: 'date', dataType: 'date', area: 'column', }, { dataField: 'sales', dataType: 'number', summaryType: 'sum', format: 'currency', area: 'data', }], store: sales, }); function OnShowColumnFieldsChanged(e) { showColumnFields.value = e.value; } function OnShowDataFieldsChanged(e) { showDataFields.value = e.value; } function OnShowFilterFieldsChanged(e) { showFilterFields.value = e.value; } function OnShowRowFieldsChanged(e) { showRowFields.value = e.value; } function onContextMenuPreparing(e) { const dataSource = e.component.getDataSource(); const sourceField = e.field; if (sourceField) { if (!sourceField.groupName || sourceField.groupIndex === 0) { e.items.push({ text: 'Hide field', onItemClick() { let fieldIndex: number; if (sourceField.groupName) { fieldIndex = dataSource .getAreaFields(sourceField.area, true)[sourceField.areaIndex] .index; } else { fieldIndex = sourceField.index; } dataSource.field(fieldIndex, { area: null, }); dataSource.load(); }, }); } if (sourceField.dataType === 'number') { const setSummaryType = function(args) { dataSource.field(sourceField.index, { summaryType: args.itemData.value, }); dataSource.load(); }; const menuItems: Record<string, any>[] = []; e.items.push({ text: 'Summary Type', items: menuItems }); ['Sum', 'Avg', 'Min', 'Max'].forEach((summaryType) => { const summaryTypeValue = summaryType.toLowerCase(); menuItems.push({ text: summaryType, value: summaryType.toLowerCase(), onItemClick: setSummaryType, selected: e.field.summaryType === summaryTypeValue, }); }); } } } </script> <style scoped> #sales { max-height: 570px; } .options { padding: 20px; margin-top: 20px; background-color: rgba(191, 191, 191, 0.15); } .caption { font-size: 18px; font-weight: 500; } .option { width: 24%; display: inline-block; margin-top: 10px; } </style>
window.exports = window.exports || {}; window.config = { transpiler: 'plugin-babel', meta: { '*.vue': { loader: 'vue-loader', }, '*.ts': { loader: 'demo-ts-loader', }, '*.svg': { loader: 'svg-loader', }, 'devextreme/time_zone_utils.js': { 'esModule': true, }, 'devextreme/localization.js': { 'esModule': true, }, 'devextreme/viz/palette.js': { 'esModule': true, }, }, paths: { 'root:': '../../../../', 'npm:': 'https://unpkg.com/', }, map: { 'vue': 'npm:vue@3.2.47/dist/vue.esm-browser.js', 'vue-loader': 'npm:dx-systemjs-vue-browser@1.1.1/index.js', 'demo-ts-loader': 'root:utils/demo-ts-loader.js', 'svg-loader': 'root:utils/svg-loader.js', 'mitt': 'npm:mitt/dist/mitt.umd.js', 'rrule': 'npm:rrule@2.6.4/dist/es5/rrule.js', 'luxon': 'npm:luxon@1.28.1/build/global/luxon.min.js', 'es6-object-assign': 'npm:es6-object-assign@1.1.0', 'devextreme': 'npm:devextreme@24.1.7/cjs', 'devextreme-vue': 'npm:devextreme-vue@24.1.7/cjs', 'jszip': 'npm:jszip@3.10.1/dist/jszip.min.js', 'devextreme-quill': 'npm:devextreme-quill@1.7.1/dist/dx-quill.min.js', 'devexpress-diagram': 'npm:devexpress-diagram@2.2.13/dist/dx-diagram.js', 'devexpress-gantt': 'npm:devexpress-gantt@4.1.56/dist/dx-gantt.js', '@devextreme/runtime': 'npm:@devextreme/runtime@3.0.13', 'inferno': 'npm:inferno@7.4.11/dist/inferno.min.js', 'inferno-compat': 'npm:inferno-compat/dist/inferno-compat.min.js', 'inferno-create-element': 'npm:inferno-create-element@7.4.11/dist/inferno-create-element.min.js', 'inferno-dom': 'npm:inferno-dom/dist/inferno-dom.min.js', 'inferno-hydrate': 'npm:inferno-hydrate@7.4.11/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', 'plugin-babel': 'npm:systemjs-plugin-babel@0.0.25/plugin-babel.js', 'systemjs-babel-build': 'npm:systemjs-plugin-babel@0.0.25/systemjs-babel-browser.js', // Prettier 'prettier/standalone': 'npm:prettier@2.8.8/standalone.js', 'prettier/parser-html': 'npm:prettier@2.8.8/parser-html.js', }, packages: { 'devextreme-vue': { main: 'index.js', }, 'devextreme': { defaultExtension: 'js', }, 'devextreme/events/utils': { main: 'index', }, 'devextreme/events': { main: 'index', }, 'es6-object-assign': { main: './index.js', defaultExtension: 'js', }, }, packageConfigPaths: [ 'npm:@devextreme/*/package.json', 'npm:@devextreme/runtime@3.0.13/inferno/package.json', ], babelOptions: { sourceMaps: false, stage0: true, }, }; System.config(window.config);
export default [{ id: 1, region: 'North America', country: 'USA', city: 'New York', sales: 1740, date: '2013/01/06', }, { id: 2, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 850, date: '2013/01/13', }, { id: 3, region: 'North America', country: 'USA', city: 'Denver', sales: 2235, date: '2013/01/07', }, { id: 4, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 1965, date: '2013/01/03', }, { id: 5, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 880, date: '2013/01/10', }, { id: 6, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 5260, date: '2013/01/17', }, { id: 7, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 2790, date: '2013/01/21', }, { id: 8, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 3140, date: '2013/01/01', }, { id: 9, region: 'Europe', country: 'GBR', city: 'London', sales: 6175, date: '2013/01/24', }, { id: 10, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 4575, date: '2013/01/11', }, { id: 11, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 3680, date: '2013/01/12', }, { id: 12, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 2260, date: '2013/01/01', }, { id: 13, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 2910, date: '2013/01/26', }, { id: 14, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 8400, date: '2013/01/05', }, { id: 15, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 1325, date: '2013/01/14', }, { id: 16, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 3920, date: '2013/01/05', }, { id: 17, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 2220, date: '2013/01/15', }, { id: 18, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 940, date: '2013/01/01', }, { id: 19, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 1630, date: '2013/01/10', }, { id: 20, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 2910, date: '2013/01/23', }, { id: 21, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 2600, date: '2013/01/14', }, { id: 22, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 4340, date: '2013/01/26', }, { id: 23, region: 'Europe', country: 'GBR', city: 'London', sales: 6650, date: '2013/01/24', }, { id: 24, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 490, date: '2013/01/22', }, { id: 25, region: 'North America', country: 'USA', city: 'New York', sales: 3390, date: '2013/01/25', }, { id: 26, region: 'North America', country: 'USA', city: 'New York', sales: 5160, date: '2013/02/20', }, { id: 27, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 5750, date: '2013/02/12', }, { id: 28, region: 'North America', country: 'USA', city: 'Denver', sales: 2805, date: '2013/02/13', }, { id: 29, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 2505, date: '2013/02/09', }, { id: 30, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 930, date: '2013/02/04', }, { id: 31, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 1240, date: '2013/02/03', }, { id: 32, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 315, date: '2013/02/04', }, { id: 33, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 2870, date: '2013/02/18', }, { id: 34, region: 'Europe', country: 'GBR', city: 'London', sales: 5150, date: '2013/02/18', }, { id: 35, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 2725, date: '2013/02/20', }, { id: 36, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 2840, date: '2013/02/04', }, { id: 37, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 5840, date: '2013/02/13', }, { id: 38, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 6750, date: '2013/02/11', }, { id: 39, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 1200, date: '2013/02/03', }, { id: 40, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 4550, date: '2013/02/08', }, { id: 41, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 6040, date: '2013/02/17', }, { id: 42, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 2205, date: '2013/02/08', }, { id: 43, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 990, date: '2013/02/20', }, { id: 44, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 700, date: '2013/02/11', }, { id: 45, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 2325, date: '2013/02/15', }, { id: 46, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 930, date: '2013/02/21', }, { id: 47, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 1560, date: '2013/02/04', }, { id: 48, region: 'North America', country: 'USA', city: 'New York', sales: 1740, date: '2013/03/04', }, { id: 49, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 3575, date: '2013/03/20', }, { id: 50, region: 'North America', country: 'USA', city: 'Denver', sales: 4500, date: '2013/03/04', }, { id: 51, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 1605, date: '2013/03/17', }, { id: 52, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 800, date: '2013/03/21', }, { id: 53, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 640, date: '2013/03/08', }, { id: 54, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 735, date: '2013/03/19', }, { id: 55, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 2520, date: '2013/03/20', }, { id: 56, region: 'Europe', country: 'GBR', city: 'London', sales: 6675, date: '2013/03/18', }, { id: 57, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 3625, date: '2013/03/25', }, { id: 58, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 1200, date: '2013/03/07', }, { id: 59, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 2000, date: '2013/03/07', }, { id: 60, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 1410, date: '2013/03/10', }, { id: 61, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 2700, date: '2013/03/19', }, { id: 62, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 5950, date: '2013/03/24', }, { id: 63, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 5120, date: '2013/03/08', }, { id: 64, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 1980, date: '2013/03/17', }, { id: 65, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 1110, date: '2013/03/08', }, { id: 66, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 980, date: '2013/03/21', }, { id: 67, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 5460, date: '2013/03/19', }, { id: 68, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 3800, date: '2013/03/12', }, { id: 69, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 2610, date: '2013/03/04', }, { id: 70, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 3080, date: '2013/03/22', }, { id: 71, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 2010, date: '2013/03/23', }, { id: 72, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 1200, date: '2013/03/04', }, { id: 73, region: 'North America', country: 'USA', city: 'New York', sales: 7680, date: '2013/04/15', }, { id: 74, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 1325, date: '2013/04/07', }, { id: 75, region: 'North America', country: 'USA', city: 'Denver', sales: 2835, date: '2013/04/10', }, { id: 76, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 3660, date: '2013/04/10', }, { id: 77, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 390, date: '2013/04/12', }, { id: 78, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 4420, date: '2013/04/08', }, { id: 79, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 1755, date: '2013/04/13', }, { id: 80, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 2580, date: '2013/04/15', }, { id: 81, region: 'Europe', country: 'GBR', city: 'London', sales: 850, date: '2013/04/01', }, { id: 82, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 2825, date: '2013/04/10', }, { id: 83, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 540, date: '2013/04/06', }, { id: 84, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 1520, date: '2013/04/08', }, { id: 85, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 8760, date: '2013/04/26', }, { id: 86, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 1110, date: '2013/04/16', }, { id: 87, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 6850, date: '2013/04/19', }, { id: 88, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 1940, date: '2013/04/23', }, { id: 89, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 1980, date: '2013/04/21', }, { id: 90, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 3090, date: '2013/04/03', }, { id: 91, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 1640, date: '2013/04/24', }, { id: 92, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 3585, date: '2013/04/01', }, { id: 93, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 1770, date: '2013/04/01', }, { id: 94, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 4005, date: '2013/04/04', }, { id: 95, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 2870, date: '2013/04/02', }, { id: 96, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 960, date: '2013/04/20', }, { id: 97, region: 'North America', country: 'USA', city: 'New York', sales: 8640, date: '2013/05/14', }, { id: 98, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 5450, date: '2013/05/24', }, { id: 99, region: 'North America', country: 'USA', city: 'Denver', sales: 2535, date: '2013/05/07', }, { id: 100, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 1155, date: '2013/05/20', }, { id: 101, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 3140, date: '2013/05/18', }, { id: 102, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 2260, date: '2013/05/19', }, { id: 103, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 1215, date: '2013/05/23', }, { id: 104, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 1210, date: '2013/05/08', }, { id: 105, region: 'Europe', country: 'GBR', city: 'London', sales: 875, date: '2013/05/25', }, { id: 106, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 5400, date: '2013/05/03', }, { id: 107, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 5940, date: '2013/05/25', }, { id: 108, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 4700, date: '2013/05/03', }, { id: 109, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 5520, date: '2013/05/12', }, { id: 110, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 9210, date: '2013/05/22', }, { id: 111, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 7950, date: '2013/05/12', }, { id: 112, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 3740, date: '2013/05/24', }, { id: 113, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 990, date: '2013/05/02', }, { id: 114, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 3190, date: '2013/05/03', }, { id: 115, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 2430, date: '2013/05/11', }, { id: 116, region: 'North America', country: 'USA', city: 'New York', sales: 7380, date: '2013/06/15', }, { id: 117, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 4475, date: '2013/06/08', }, { id: 118, region: 'North America', country: 'USA', city: 'Denver', sales: 1290, date: '2013/06/10', }, { id: 119, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 2250, date: '2013/06/10', }, { id: 120, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 350, date: '2013/06/22', }, { id: 121, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 5480, date: '2013/06/24', }, { id: 122, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 2355, date: '2013/06/10', }, { id: 123, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 1960, date: '2013/06/23', }, { id: 124, region: 'Europe', country: 'GBR', city: 'London', sales: 4125, date: '2013/06/06', }, { id: 125, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 7925, date: '2013/06/12', }, { id: 126, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 1120, date: '2013/06/22', }, { id: 127, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 5100, date: '2013/06/01', }, { id: 128, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 1500, date: '2013/06/25', }, { id: 129, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 5130, date: '2013/06/10', }, { id: 130, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 2475, date: '2013/06/10', }, { id: 131, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 2100, date: '2013/06/06', }, { id: 132, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 3570, date: '2013/06/10', }, { id: 133, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 550, date: '2013/06/02', }, { id: 134, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 2850, date: '2013/06/26', }, { id: 135, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 4280, date: '2013/06/19', }, { id: 136, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 1460, date: '2013/06/17', }, { id: 137, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 960, date: '2013/06/17', }, { id: 138, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 1520, date: '2013/06/03', }, { id: 139, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 6750, date: '2013/06/21', }, { id: 140, region: 'North America', country: 'USA', city: 'New York', sales: 7260, date: '2013/07/14', }, { id: 141, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 2450, date: '2013/07/11', }, { id: 142, region: 'North America', country: 'USA', city: 'Denver', sales: 3540, date: '2013/07/02', }, { id: 143, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 1950, date: '2013/07/03', }, { id: 144, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 360, date: '2013/07/07', }, { id: 145, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 4500, date: '2013/07/03', }, { id: 146, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 4575, date: '2013/07/21', }, { id: 147, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 2310, date: '2013/07/18', }, { id: 148, region: 'Europe', country: 'GBR', city: 'London', sales: 7500, date: '2013/07/04', }, { id: 149, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 3575, date: '2013/07/23', }, { id: 150, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 760, date: '2013/07/01', }, { id: 151, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 2400, date: '2013/07/11', }, { id: 152, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 3330, date: '2013/07/04', }, { id: 153, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 3480, date: '2013/07/23', }, { id: 154, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 4875, date: '2013/07/11', }, { id: 155, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 4980, date: '2013/07/19', }, { id: 156, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 2580, date: '2013/07/04', }, { id: 157, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 2650, date: '2013/07/16', }, { id: 158, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 1190, date: '2013/07/02', }, { id: 159, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 960, date: '2013/07/26', }, { id: 160, region: 'North America', country: 'USA', city: 'New York', sales: 3600, date: '2013/08/08', }, { id: 161, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 2250, date: '2013/08/01', }, { id: 162, region: 'North America', country: 'USA', city: 'Denver', sales: 1275, date: '2013/08/02', }, { id: 163, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 3885, date: '2013/08/14', }, { id: 164, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 1900, date: '2013/08/05', }, { id: 165, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 2300, date: '2013/08/09', }, { id: 166, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 2895, date: '2013/08/15', }, { id: 167, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 350, date: '2013/08/20', }, { id: 168, region: 'Europe', country: 'GBR', city: 'London', sales: 4200, date: '2013/08/22', }, { id: 169, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 7175, date: '2013/08/14', }, { id: 170, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 4420, date: '2013/08/24', }, { id: 171, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 5200, date: '2013/08/21', }, { id: 172, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 7920, date: '2013/08/17', }, { id: 173, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 6990, date: '2013/08/22', }, { id: 174, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 2125, date: '2013/08/05', }, { id: 175, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 2220, date: '2013/08/16', }, { id: 176, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 1575, date: '2013/08/23', }, { id: 177, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 1880, date: '2013/08/12', }, { id: 178, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 710, date: '2013/08/25', }, { id: 179, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 390, date: '2013/08/20', }, { id: 180, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 4635, date: '2013/08/04', }, { id: 181, region: 'North America', country: 'USA', city: 'Denver', sales: 4350, date: '2013/08/19', }, { id: 182, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 6020, date: '2013/08/02', }, { id: 183, region: 'North America', country: 'USA', city: 'New York', sales: 3660, date: '2013/08/19', }, { id: 184, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 4525, date: '2013/08/24', }, { id: 185, region: 'North America', country: 'USA', city: 'New York', sales: 4410, date: '2013/09/12', }, { id: 186, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 1725, date: '2013/09/07', }, { id: 187, region: 'North America', country: 'USA', city: 'Denver', sales: 2715, date: '2013/09/14', }, { id: 188, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 2820, date: '2013/09/08', }, { id: 189, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 2310, date: '2013/09/12', }, { id: 190, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 780, date: '2013/09/08', }, { id: 191, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 2370, date: '2013/09/19', }, { id: 192, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 1410, date: '2013/09/09', }, { id: 193, region: 'Europe', country: 'GBR', city: 'London', sales: 1825, date: '2013/09/23', }, { id: 194, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 4075, date: '2013/09/06', }, { id: 195, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 1020, date: '2013/09/04', }, { id: 196, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 4320, date: '2013/09/25', }, { id: 197, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 7530, date: '2013/09/13', }, { id: 198, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 2820, date: '2013/09/08', }, { id: 199, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 3050, date: '2013/09/04', }, { id: 200, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 5080, date: '2013/09/25', }, { id: 201, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 1125, date: '2013/09/13', }, { id: 202, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 850, date: '2013/09/24', }, { id: 203, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 1440, date: '2013/09/19', }, { id: 204, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 1950, date: '2013/09/02', }, { id: 205, region: 'North America', country: 'USA', city: 'New York', sales: 6390, date: '2013/10/11', }, { id: 206, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 4625, date: '2013/10/02', }, { id: 207, region: 'North America', country: 'USA', city: 'Denver', sales: 3510, date: '2013/10/24', }, { id: 208, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 2730, date: '2013/10/15', }, { id: 209, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 2070, date: '2013/10/15', }, { id: 210, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 2320, date: '2013/10/18', }, { id: 211, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 4260, date: '2013/10/24', }, { id: 212, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 840, date: '2013/10/18', }, { id: 213, region: 'Europe', country: 'GBR', city: 'London', sales: 7300, date: '2013/10/24', }, { id: 214, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 5950, date: '2013/10/11', }, { id: 215, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 3220, date: '2013/10/25', }, { id: 216, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 3480, date: '2013/10/08', }, { id: 217, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 4830, date: '2013/10/26', }, { id: 218, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 4470, date: '2013/10/05', }, { id: 219, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 3675, date: '2013/10/23', }, { id: 220, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 4260, date: '2013/10/01', }, { id: 221, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 4245, date: '2013/10/26', }, { id: 222, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 1470, date: '2013/10/01', }, { id: 223, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 1810, date: '2013/10/02', }, { id: 224, region: 'North America', country: 'USA', city: 'New York', sales: 600, date: '2013/10/23', }, { id: 225, region: 'North America', country: 'USA', city: 'New York', sales: 7500, date: '2013/11/03', }, { id: 226, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 4625, date: '2013/11/02', }, { id: 227, region: 'North America', country: 'USA', city: 'Denver', sales: 2625, date: '2013/11/09', }, { id: 228, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 1440, date: '2013/11/15', }, { id: 229, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 2420, date: '2013/11/15', }, { id: 230, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 4180, date: '2013/11/15', }, { id: 231, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 3720, date: '2013/11/25', }, { id: 232, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 2730, date: '2013/11/08', }, { id: 233, region: 'Europe', country: 'GBR', city: 'London', sales: 3775, date: '2013/11/17', }, { id: 234, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 3525, date: '2013/11/15', }, { id: 235, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 5320, date: '2013/11/08', }, { id: 236, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 5340, date: '2013/11/13', }, { id: 237, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 8850, date: '2013/11/01', }, { id: 238, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 7050, date: '2013/11/14', }, { id: 239, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 4200, date: '2013/11/18', }, { id: 240, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 4960, date: '2013/11/04', }, { id: 241, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 2280, date: '2013/11/13', }, { id: 242, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 590, date: '2013/11/11', }, { id: 243, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 810, date: '2013/11/12', }, { id: 244, region: 'Europe', country: 'GBR', city: 'London', sales: 2625, date: '2013/11/07', }, { id: 245, region: 'North America', country: 'USA', city: 'New York', sales: 8280, date: '2013/12/01', }, { id: 246, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 5650, date: '2013/12/19', }, { id: 247, region: 'North America', country: 'USA', city: 'Denver', sales: 2760, date: '2013/12/14', }, { id: 248, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 2670, date: '2013/12/03', }, { id: 249, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 2520, date: '2013/12/20', }, { id: 250, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 4080, date: '2013/12/21', }, { id: 251, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 4140, date: '2013/12/22', }, { id: 252, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 390, date: '2013/12/04', }, { id: 253, region: 'Europe', country: 'GBR', city: 'London', sales: 1400, date: '2013/12/19', }, { id: 254, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 7275, date: '2013/12/22', }, { id: 255, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 4100, date: '2013/12/20', }, { id: 256, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 5520, date: '2013/12/25', }, { id: 257, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 9210, date: '2013/12/24', }, { id: 258, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 7290, date: '2013/12/05', }, { id: 259, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 625, date: '2013/12/22', }, { id: 260, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 4460, date: '2013/12/12', }, { id: 261, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 3825, date: '2013/12/13', }, { id: 262, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 2850, date: '2013/12/17', }, { id: 263, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 2780, date: '2013/12/07', }, { id: 264, region: 'North America', country: 'USA', city: 'New York', sales: 840, date: '2013/12/18', }, { id: 265, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 2970, date: '2013/12/23', }, { id: 266, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 945, date: '2013/12/06', }, { id: 267, region: 'North America', country: 'USA', city: 'Denver', sales: 2625, date: '2013/12/04', }, { id: 268, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 390, date: '2013/12/01', }, { id: 269, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 2250, date: '2013/12/02', }, { id: 270, region: 'North America', country: 'USA', city: 'New York', sales: 7710, date: '2014/01/18', }, { id: 271, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 7975, date: '2014/01/10', }, { id: 272, region: 'North America', country: 'USA', city: 'Denver', sales: 3285, date: '2014/01/13', }, { id: 273, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 2580, date: '2014/01/22', }, { id: 274, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 2160, date: '2014/01/26', }, { id: 275, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 1100, date: '2014/01/25', }, { id: 276, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 4425, date: '2014/01/21', }, { id: 277, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 1360, date: '2014/01/22', }, { id: 278, region: 'Europe', country: 'GBR', city: 'London', sales: 3250, date: '2014/01/14', }, { id: 279, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 5550, date: '2014/01/21', }, { id: 280, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 2860, date: '2014/01/25', }, { id: 281, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 5320, date: '2014/01/08', }, { id: 282, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 4050, date: '2014/01/14', }, { id: 283, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 3450, date: '2014/01/24', }, { id: 284, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 5425, date: '2014/01/11', }, { id: 285, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 4860, date: '2014/01/12', }, { id: 286, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 4695, date: '2014/01/16', }, { id: 287, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 610, date: '2014/01/05', }, { id: 288, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 1580, date: '2014/01/15', }, { id: 289, region: 'North America', country: 'USA', city: 'New York', sales: 3780, date: '2014/02/18', }, { id: 290, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 5400, date: '2014/02/21', }, { id: 291, region: 'North America', country: 'USA', city: 'Denver', sales: 630, date: '2014/02/18', }, { id: 292, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 3960, date: '2014/02/04', }, { id: 293, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 2010, date: '2014/02/25', }, { id: 294, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 5000, date: '2014/02/01', }, { id: 295, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 1995, date: '2014/02/20', }, { id: 296, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 860, date: '2014/02/12', }, { id: 297, region: 'Europe', country: 'GBR', city: 'London', sales: 2150, date: '2014/02/10', }, { id: 298, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 4050, date: '2014/02/06', }, { id: 299, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 2960, date: '2014/02/18', }, { id: 300, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 1780, date: '2014/02/26', }, { id: 301, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 8700, date: '2014/02/03', }, { id: 302, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 3390, date: '2014/02/03', }, { id: 303, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 4425, date: '2014/02/15', }, { id: 304, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 1180, date: '2014/02/23', }, { id: 305, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 360, date: '2014/02/08', }, { id: 306, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 2310, date: '2014/02/13', }, { id: 307, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 1770, date: '2014/02/20', }, { id: 308, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 3060, date: '2014/02/26', }, { id: 309, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 1750, date: '2014/02/12', }, { id: 310, region: 'North America', country: 'USA', city: 'New York', sales: 2280, date: '2014/03/09', }, { id: 311, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 7600, date: '2014/03/25', }, { id: 312, region: 'North America', country: 'USA', city: 'Denver', sales: 1035, date: '2014/03/23', }, { id: 313, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 1245, date: '2014/03/01', }, { id: 314, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 2860, date: '2014/03/19', }, { id: 315, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 440, date: '2014/03/19', }, { id: 316, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 4665, date: '2014/03/02', }, { id: 317, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 2270, date: '2014/03/15', }, { id: 318, region: 'Europe', country: 'GBR', city: 'London', sales: 5000, date: '2014/03/09', }, { id: 319, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 5100, date: '2014/03/23', }, { id: 320, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 2120, date: '2014/03/11', }, { id: 321, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 5140, date: '2014/03/05', }, { id: 322, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 6210, date: '2014/03/19', }, { id: 323, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 9510, date: '2014/03/19', }, { id: 324, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 7600, date: '2014/03/21', }, { id: 325, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 5420, date: '2014/03/15', }, { id: 326, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 1980, date: '2014/03/05', }, { id: 327, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 1820, date: '2014/03/07', }, { id: 328, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 1670, date: '2014/03/21', }, { id: 329, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 4800, date: '2014/03/08', }, { id: 330, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 2925, date: '2014/03/03', }, { id: 331, region: 'North America', country: 'USA', city: 'New York', sales: 2940, date: '2014/04/11', }, { id: 332, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 3525, date: '2014/04/13', }, { id: 333, region: 'North America', country: 'USA', city: 'Denver', sales: 2475, date: '2014/04/22', }, { id: 334, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 3315, date: '2014/04/08', }, { id: 335, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 3140, date: '2014/04/07', }, { id: 336, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 2520, date: '2014/04/01', }, { id: 337, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 1200, date: '2014/04/10', }, { id: 338, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 2060, date: '2014/04/21', }, { id: 339, region: 'Europe', country: 'GBR', city: 'London', sales: 7875, date: '2014/04/02', }, { id: 340, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 1450, date: '2014/04/07', }, { id: 341, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 2640, date: '2014/04/22', }, { id: 342, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 1960, date: '2014/04/16', }, { id: 343, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 2250, date: '2014/04/23', }, { id: 344, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 4500, date: '2014/04/05', }, { id: 345, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 5050, date: '2014/04/11', }, { id: 346, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 2940, date: '2014/04/02', }, { id: 347, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 2880, date: '2014/04/14', }, { id: 348, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 1050, date: '2014/04/19', }, { id: 349, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 1850, date: '2014/04/02', }, { id: 350, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 3160, date: '2014/04/01', }, { id: 351, region: 'Europe', country: 'GBR', city: 'London', sales: 875, date: '2014/04/04', }, { id: 352, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 3200, date: '2014/04/08', }, { id: 353, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 1380, date: '2014/04/21', }, { id: 354, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 3060, date: '2014/04/06', }, { id: 355, region: 'North America', country: 'USA', city: 'New York', sales: 6690, date: '2014/05/19', }, { id: 356, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 4525, date: '2014/05/15', }, { id: 357, region: 'North America', country: 'USA', city: 'Denver', sales: 4665, date: '2014/05/10', }, { id: 358, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 4530, date: '2014/05/18', }, { id: 359, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 1330, date: '2014/05/08', }, { id: 360, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 1720, date: '2014/05/20', }, { id: 361, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 3750, date: '2014/05/16', }, { id: 362, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 1290, date: '2014/05/10', }, { id: 363, region: 'Europe', country: 'GBR', city: 'London', sales: 4925, date: '2014/05/14', }, { id: 364, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 4300, date: '2014/05/22', }, { id: 365, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 5740, date: '2014/05/08', }, { id: 366, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 3760, date: '2014/05/18', }, { id: 367, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 7920, date: '2014/05/22', }, { id: 368, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 1440, date: '2014/05/21', }, { id: 369, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 5975, date: '2014/05/25', }, { id: 370, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 4440, date: '2014/05/05', }, { id: 371, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 2310, date: '2014/05/24', }, { id: 372, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 2250, date: '2014/05/06', }, { id: 373, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 2320, date: '2014/05/14', }, { id: 374, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 8370, date: '2014/05/06', }, { id: 375, region: 'North America', country: 'USA', city: 'New York', sales: 5190, date: '2014/06/26', }, { id: 376, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 925, date: '2014/06/04', }, { id: 377, region: 'North America', country: 'USA', city: 'Denver', sales: 3240, date: '2014/06/20', }, { id: 378, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 3180, date: '2014/06/23', }, { id: 379, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 780, date: '2014/06/13', }, { id: 380, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 4680, date: '2014/06/08', }, { id: 381, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 2475, date: '2014/06/25', }, { id: 382, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 1920, date: '2014/06/20', }, { id: 383, region: 'Europe', country: 'GBR', city: 'London', sales: 7500, date: '2014/06/25', }, { id: 384, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 5025, date: '2014/06/26', }, { id: 385, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 2400, date: '2014/06/08', }, { id: 386, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 1720, date: '2014/06/09', }, { id: 387, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 2880, date: '2014/06/21', }, { id: 388, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 5430, date: '2014/06/03', }, { id: 389, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 4475, date: '2014/06/19', }, { id: 390, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 1420, date: '2014/06/20', }, { id: 391, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 2670, date: '2014/06/25', }, { id: 392, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 1930, date: '2014/06/02', }, { id: 393, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 580, date: '2014/06/25', }, { id: 394, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 1620, date: '2014/06/12', }, { id: 395, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 4530, date: '2014/06/02', }, { id: 396, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 6025, date: '2014/06/23', }, { id: 397, region: 'North America', country: 'USA', city: 'New York', sales: 3540, date: '2014/07/21', }, { id: 398, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 3000, date: '2014/07/01', }, { id: 399, region: 'North America', country: 'USA', city: 'Denver', sales: 3240, date: '2014/07/26', }, { id: 400, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 2265, date: '2014/07/22', }, { id: 401, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 400, date: '2014/07/09', }, { id: 402, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 1460, date: '2014/07/08', }, { id: 403, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 1620, date: '2014/07/18', }, { id: 404, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 2400, date: '2014/07/25', }, { id: 405, region: 'Europe', country: 'GBR', city: 'London', sales: 5275, date: '2014/07/04', }, { id: 406, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 4475, date: '2014/07/03', }, { id: 407, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 3980, date: '2014/07/21', }, { id: 408, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 5240, date: '2014/07/11', }, { id: 409, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 1200, date: '2014/07/21', }, { id: 410, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 5700, date: '2014/07/18', }, { id: 411, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 5575, date: '2014/07/01', }, { id: 412, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 2160, date: '2014/07/02', }, { id: 413, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 960, date: '2014/07/09', }, { id: 414, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 1280, date: '2014/07/04', }, { id: 415, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 1040, date: '2014/07/02', }, { id: 416, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 5520, date: '2014/07/21', }, { id: 417, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 1760, date: '2014/07/25', }, { id: 418, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 4080, date: '2014/07/07', }, { id: 419, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 1000, date: '2014/07/21', }, { id: 420, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 3270, date: '2014/07/12', }, { id: 421, region: 'North America', country: 'USA', city: 'New York', sales: 1770, date: '2014/08/23', }, { id: 422, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 2700, date: '2014/08/09', }, { id: 423, region: 'North America', country: 'USA', city: 'Denver', sales: 2175, date: '2014/08/03', }, { id: 424, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 3375, date: '2014/08/11', }, { id: 425, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 2040, date: '2014/08/01', }, { id: 426, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 3000, date: '2014/08/21', }, { id: 427, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 3900, date: '2014/08/16', }, { id: 428, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 1370, date: '2014/08/20', }, { id: 429, region: 'Europe', country: 'GBR', city: 'London', sales: 5700, date: '2014/08/01', }, { id: 430, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 1275, date: '2014/08/22', }, { id: 431, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 4060, date: '2014/08/13', }, { id: 432, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 2320, date: '2014/08/18', }, { id: 433, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 7590, date: '2014/08/24', }, { id: 434, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 4560, date: '2014/08/20', }, { id: 435, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 7575, date: '2014/08/20', }, { id: 436, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 700, date: '2014/08/25', }, { id: 437, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 2400, date: '2014/08/16', }, { id: 438, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 1390, date: '2014/08/15', }, { id: 439, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 1320, date: '2014/08/09', }, { id: 440, region: 'North America', country: 'USA', city: 'Denver', sales: 1680, date: '2014/08/09', }, { id: 441, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 1500, date: '2014/08/11', }, { id: 442, region: 'North America', country: 'USA', city: 'New York', sales: 6150, date: '2014/09/21', }, { id: 443, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 3675, date: '2014/09/02', }, { id: 444, region: 'North America', country: 'USA', city: 'Denver', sales: 2250, date: '2014/09/05', }, { id: 445, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 3585, date: '2014/09/10', }, { id: 446, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 1470, date: '2014/09/01', }, { id: 447, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 2260, date: '2014/09/02', }, { id: 448, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 3765, date: '2014/09/03', }, { id: 449, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 1640, date: '2014/09/04', }, { id: 450, region: 'Europe', country: 'GBR', city: 'London', sales: 4475, date: '2014/09/09', }, { id: 451, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 5975, date: '2014/09/04', }, { id: 452, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 1100, date: '2014/09/16', }, { id: 453, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 1320, date: '2014/09/18', }, { id: 454, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 8610, date: '2014/09/19', }, { id: 455, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 9210, date: '2014/09/09', }, { id: 456, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 3700, date: '2014/09/01', }, { id: 457, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 3620, date: '2014/09/19', }, { id: 458, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 4275, date: '2014/09/01', }, { id: 459, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 2370, date: '2014/09/03', }, { id: 460, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 1870, date: '2014/09/10', }, { id: 461, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 2070, date: '2014/09/25', }, { id: 462, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 5025, date: '2014/09/19', }, { id: 463, region: 'North America', country: 'USA', city: 'New York', sales: 1080, date: '2014/10/15', }, { id: 464, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 1400, date: '2014/10/22', }, { id: 465, region: 'North America', country: 'USA', city: 'Denver', sales: 4260, date: '2014/10/01', }, { id: 466, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 2745, date: '2014/10/01', }, { id: 467, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 2920, date: '2014/10/23', }, { id: 468, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 3520, date: '2014/10/11', }, { id: 469, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 4035, date: '2014/10/20', }, { id: 470, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 1730, date: '2014/10/05', }, { id: 471, region: 'Europe', country: 'GBR', city: 'London', sales: 975, date: '2014/10/06', }, { id: 472, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 5700, date: '2014/10/06', }, { id: 473, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 5080, date: '2014/10/18', }, { id: 474, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 2940, date: '2014/10/24', }, { id: 475, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 2670, date: '2014/10/04', }, { id: 476, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 1230, date: '2014/10/11', }, { id: 477, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 600, date: '2014/10/08', }, { id: 478, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 3700, date: '2014/10/08', }, { id: 479, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 3375, date: '2014/10/11', }, { id: 480, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 1500, date: '2014/10/17', }, { id: 481, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 370, date: '2014/10/05', }, { id: 482, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 2340, date: '2014/10/16', }, { id: 483, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 1080, date: '2014/10/08', }, { id: 484, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 2775, date: '2014/10/21', }, { id: 485, region: 'North America', country: 'USA', city: 'New York', sales: 4380, date: '2014/11/09', }, { id: 486, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 5500, date: '2014/11/21', }, { id: 487, region: 'North America', country: 'USA', city: 'Denver', sales: 1920, date: '2014/11/24', }, { id: 488, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 765, date: '2014/11/24', }, { id: 489, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 370, date: '2014/11/18', }, { id: 490, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 3500, date: '2014/11/25', }, { id: 491, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 825, date: '2014/11/09', }, { id: 492, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 490, date: '2014/11/23', }, { id: 493, region: 'Europe', country: 'GBR', city: 'London', sales: 7075, date: '2014/11/20', }, { id: 494, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 1350, date: '2014/11/25', }, { id: 495, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 1440, date: '2014/11/15', }, { id: 496, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 2820, date: '2014/11/13', }, { id: 497, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 2280, date: '2014/11/12', }, { id: 498, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 1110, date: '2014/11/03', }, { id: 499, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 1150, date: '2014/11/23', }, { id: 500, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 2040, date: '2014/11/20', }, { id: 501, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 3090, date: '2014/11/24', }, { id: 502, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 1940, date: '2014/11/24', }, { id: 503, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 3090, date: '2014/11/16', }, { id: 504, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 4900, date: '2014/11/05', }, { id: 505, region: 'North America', country: 'USA', city: 'Denver', sales: 3465, date: '2014/11/07', }, { id: 506, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 1110, date: '2014/11/20', }, { id: 507, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 1650, date: '2014/11/02', }, { id: 508, region: 'North America', country: 'USA', city: 'New York', sales: 5280, date: '2014/12/04', }, { id: 509, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 3075, date: '2014/12/02', }, { id: 510, region: 'North America', country: 'USA', city: 'Denver', sales: 690, date: '2014/12/07', }, { id: 511, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 1305, date: '2014/12/15', }, { id: 512, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 1970, date: '2014/12/01', }, { id: 513, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 3760, date: '2014/12/18', }, { id: 514, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 1920, date: '2014/12/22', }, { id: 515, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 1360, date: '2014/12/12', }, { id: 516, region: 'Europe', country: 'GBR', city: 'London', sales: 2525, date: '2014/12/06', }, { id: 517, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 5575, date: '2014/12/20', }, { id: 518, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 5560, date: '2014/12/10', }, { id: 519, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 4880, date: '2014/12/13', }, { id: 520, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 8850, date: '2014/12/03', }, { id: 521, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 2820, date: '2014/12/10', }, { id: 522, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 4000, date: '2014/12/12', }, { id: 523, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 5820, date: '2014/12/02', }, { id: 524, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 1275, date: '2014/12/12', }, { id: 525, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 1310, date: '2014/12/01', }, { id: 526, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 2180, date: '2014/12/26', }, { id: 527, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 4470, date: '2014/12/17', }, { id: 528, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 2990, date: '2014/12/15', }, { id: 529, region: 'Europe', country: 'GBR', city: 'London', sales: 7650, date: '2014/12/18', }, { id: 530, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 780, date: '2014/12/02', }, { id: 531, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 2970, date: '2014/12/13', }, { id: 532, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 1155, date: '2014/12/05', }, { id: 533, region: 'North America', country: 'USA', city: 'New York', sales: 4470, date: '2015/01/10', }, { id: 534, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 1125, date: '2015/01/21', }, { id: 535, region: 'North America', country: 'USA', city: 'Denver', sales: 645, date: '2015/01/17', }, { id: 536, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 675, date: '2015/01/05', }, { id: 537, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 2840, date: '2015/01/05', }, { id: 538, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 2660, date: '2015/01/04', }, { id: 539, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 4560, date: '2015/01/12', }, { id: 540, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 2880, date: '2015/01/20', }, { id: 541, region: 'Europe', country: 'GBR', city: 'London', sales: 500, date: '2015/01/02', }, { id: 542, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 3925, date: '2015/01/07', }, { id: 543, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 5660, date: '2015/01/18', }, { id: 544, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 1460, date: '2015/01/22', }, { id: 545, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 5040, date: '2015/01/10', }, { id: 546, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 4830, date: '2015/01/13', }, { id: 547, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 3075, date: '2015/01/22', }, { id: 548, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 3120, date: '2015/01/14', }, { id: 549, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 3525, date: '2015/01/23', }, { id: 550, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 1930, date: '2015/01/09', }, { id: 551, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 2890, date: '2015/01/02', }, { id: 552, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 1545, date: '2015/01/17', }, { id: 553, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 3630, date: '2015/01/20', }, { id: 554, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 4035, date: '2015/01/14', }, { id: 555, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 345, date: '2015/01/06', }, { id: 556, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 7000, date: '2015/01/07', }, { id: 557, region: 'North America', country: 'USA', city: 'New York', sales: 3060, date: '2015/02/13', }, { id: 558, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 6425, date: '2015/02/04', }, { id: 559, region: 'North America', country: 'USA', city: 'Denver', sales: 615, date: '2015/02/22', }, { id: 560, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 1755, date: '2015/02/07', }, { id: 561, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 1540, date: '2015/02/21', }, { id: 562, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 2820, date: '2015/02/24', }, { id: 563, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 4305, date: '2015/02/10', }, { id: 564, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 1520, date: '2015/02/26', }, { id: 565, region: 'Europe', country: 'GBR', city: 'London', sales: 4725, date: '2015/02/18', }, { id: 566, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 6750, date: '2015/02/16', }, { id: 567, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 5540, date: '2015/02/07', }, { id: 568, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 1880, date: '2015/02/24', }, { id: 569, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 6180, date: '2015/02/26', }, { id: 570, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 9300, date: '2015/02/03', }, { id: 571, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 3700, date: '2015/02/26', }, { id: 572, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 740, date: '2015/02/01', }, { id: 573, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 4755, date: '2015/02/23', }, { id: 574, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 2570, date: '2015/02/20', }, { id: 575, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 2860, date: '2015/02/19', }, { id: 576, region: 'North America', country: 'USA', city: 'New York', sales: 5430, date: '2015/03/21', }, { id: 577, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 4525, date: '2015/03/21', }, { id: 578, region: 'North America', country: 'USA', city: 'Denver', sales: 1515, date: '2015/03/10', }, { id: 579, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 630, date: '2015/03/15', }, { id: 580, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 1310, date: '2015/03/01', }, { id: 581, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 3200, date: '2015/03/17', }, { id: 582, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 3945, date: '2015/03/20', }, { id: 583, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 2990, date: '2015/03/18', }, { id: 584, region: 'Europe', country: 'GBR', city: 'London', sales: 1125, date: '2015/03/22', }, { id: 585, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 7950, date: '2015/03/17', }, { id: 586, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 2960, date: '2015/03/25', }, { id: 587, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 6300, date: '2015/03/20', }, { id: 588, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 8670, date: '2015/03/07', }, { id: 589, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 3930, date: '2015/03/23', }, { id: 590, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 6975, date: '2015/03/02', }, { id: 591, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 4220, date: '2015/03/17', }, { id: 592, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 3090, date: '2015/03/25', }, { id: 593, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 2380, date: '2015/03/01', }, { id: 594, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 1510, date: '2015/03/07', }, { id: 595, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 1020, date: '2015/03/19', }, { id: 596, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 6700, date: '2015/03/26', }, { id: 597, region: 'North America', country: 'USA', city: 'New York', sales: 4890, date: '2015/04/02', }, { id: 598, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 7225, date: '2015/04/13', }, { id: 599, region: 'North America', country: 'USA', city: 'Denver', sales: 795, date: '2015/04/07', }, { id: 600, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 1785, date: '2015/04/03', }, { id: 601, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 1850, date: '2015/04/03', }, { id: 602, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 5120, date: '2015/04/12', }, { id: 603, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 615, date: '2015/04/07', }, { id: 604, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 2860, date: '2015/04/05', }, { id: 605, region: 'Europe', country: 'GBR', city: 'London', sales: 1525, date: '2015/04/24', }, { id: 606, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 7425, date: '2015/04/15', }, { id: 607, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 6080, date: '2015/04/13', }, { id: 608, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 2940, date: '2015/04/04', }, { id: 609, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 5580, date: '2015/04/16', }, { id: 610, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 9390, date: '2015/04/19', }, { id: 611, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 3200, date: '2015/04/26', }, { id: 612, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 4380, date: '2015/04/05', }, { id: 613, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 4725, date: '2015/04/06', }, { id: 614, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 930, date: '2015/04/25', }, { id: 615, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 1910, date: '2015/04/05', }, { id: 616, region: 'Europe', country: 'GBR', city: 'London', sales: 2725, date: '2015/04/16', }, { id: 617, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 4720, date: '2015/04/02', }, { id: 618, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 5190, date: '2015/04/10', }, { id: 619, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 2800, date: '2015/04/26', }, { id: 620, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 3780, date: '2015/04/24', }, { id: 621, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 2340, date: '2015/04/17', }, { id: 622, region: 'North America', country: 'USA', city: 'New York', sales: 4830, date: '2015/05/12', }, { id: 623, region: 'North America', country: 'USA', city: 'Los Angeles', sales: 2075, date: '2015/05/23', }, { id: 624, region: 'North America', country: 'USA', city: 'Denver', sales: 3420, date: '2015/05/21', }, { id: 625, region: 'North America', country: 'CAN', city: 'Vancouver', sales: 1440, date: '2015/05/10', }, { id: 626, region: 'North America', country: 'CAN', city: 'Edmonton', sales: 1680, date: '2015/05/15', }, { id: 627, region: 'South America', country: 'BRA', city: 'Rio de Janeiro', sales: 3440, date: '2015/05/16', }, { id: 628, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 4695, date: '2015/05/10', }, { id: 629, region: 'South America', country: 'PRY', city: 'Asuncion', sales: 2380, date: '2015/05/06', }, { id: 630, region: 'Europe', country: 'GBR', city: 'London', sales: 1875, date: '2015/05/25', }, { id: 631, region: 'Europe', country: 'DEU', city: 'Berlin', sales: 7550, date: '2015/05/14', }, { id: 632, region: 'Europe', country: 'ESP', city: 'Madrid', sales: 3340, date: '2015/05/01', }, { id: 633, region: 'Europe', country: 'RUS', city: 'Moscow', sales: 1400, date: '2015/05/22', }, { id: 634, region: 'Asia', country: 'CHN', city: 'Beijing', sales: 6060, date: '2015/05/22', }, { id: 635, region: 'Asia', country: 'JPN', city: 'Tokyo', sales: 8370, date: '2015/05/13', }, { id: 636, region: 'Asia', country: 'KOR', city: 'Seoul', sales: 3550, date: '2015/05/26', }, { id: 637, region: 'Australia', country: 'AUS', city: 'Sydney', sales: 2620, date: '2015/05/17', }, { id: 638, region: 'Australia', country: 'AUS', city: 'Melbourne', sales: 2400, date: '2015/05/21', }, { id: 639, region: 'Africa', country: 'ZAF', city: 'Pretoria', sales: 1740, date: '2015/05/21', }, { id: 640, region: 'Africa', country: 'EGY', city: 'Cairo', sales: 500, date: '2015/05/26', }, { id: 641, region: 'South America', country: 'ARG', city: 'Buenos Aires', sales: 780, date: '2015/05/07', }];
import { createApp } from 'vue'; import App from './App.vue'; createApp(App).mount('#app');
<!DOCTYPE html> <html 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/24.1.7/css/dx.light.css" /> <script src="https://unpkg.com/typescript@4.9.5/lib/typescript.js"></script> <script type="module"> import * as vueCompilerSFC from "https://unpkg.com/@vue/compiler-sfc@3.4.16/dist/compiler-sfc.esm-browser.js"; window.vueCompilerSFC = vueCompilerSFC; </script> <script src="https://unpkg.com/core-js@2.6.12/client/shim.min.js"></script> <script src="https://unpkg.com/systemjs@0.21.3/dist/system.js"></script> <script type="text/javascript" src="config.js"></script> <script type="text/javascript"> System.import("./index.ts"); </script> </head> <body class="dx-viewport"> <div class="demo-container"> <div id="app" /> </div> </body> </html>

In this demo, you can click the checkboxes below the PivotGrid to enable or disable these properties.

If you do not want users to drag and drop fields, disable the fieldPanel.allowFieldDragging property. In this case, the users can only use the field chooser to reorganize the fields.

The field panel also allows users to sort and filter pivot grid fields. Click a field to change the sort order. Click a funnel icon to open the filter popup. To enable these features, set the allowSorting and allowFiltering properties to true.

This demo also shows how to add custom commands to a field's context menu. For instance, right-click the Sales (Sum) field, and you will see three commands. Two of them (Hide field and Summary Type) are custom. Review the onContextMenuPreparing handler implemenation to see how these commands are added to the context menu. For more information, refer to the following help topic: onContextMenuPreparing.