DevExtreme v24.1 is now available.

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

Your search did not match any results.

JavaScript/jQuery 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
$(() => { const salesPivotGrid = $('#sales').dxPivotGrid({ allowSortingBySummary: true, allowSorting: true, allowFiltering: true, height: 490, showBorders: true, fieldPanel: { showColumnFields: true, showDataFields: true, showFilterFields: true, showRowFields: true, allowFieldDragging: true, visible: true, }, fieldChooser: { height: 500, }, dataSource: { 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, }, onContextMenuPreparing: contextMenuPreparing, }).dxPivotGrid('instance'); $('#show-data-fields').dxCheckBox({ text: 'Show Data Fields', value: true, onValueChanged(data) { salesPivotGrid.option('fieldPanel.showDataFields', data.value); }, }); $('#show-row-fields').dxCheckBox({ text: 'Show Row Fields', value: true, onValueChanged(data) { salesPivotGrid.option('fieldPanel.showRowFields', data.value); }, }); $('#show-column-fields').dxCheckBox({ text: 'Show Column Fields', value: true, onValueChanged(data) { salesPivotGrid.option('fieldPanel.showColumnFields', data.value); }, }); $('#show-filter-fields').dxCheckBox({ text: 'Show Filter Fields', value: true, onValueChanged(data) { salesPivotGrid.option('fieldPanel.showFilterFields', data.value); }, }); function contextMenuPreparing(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; 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 = []; e.items.push({ text: 'Summary Type', items: menuItems }); $.each(['Sum', 'Avg', 'Min', 'Max'], (_, summaryType) => { const summaryTypeValue = summaryType.toLowerCase(); menuItems.push({ text: summaryType, value: summaryType.toLowerCase(), onItemClick: setSummaryType, selected: e.field.summaryType === summaryTypeValue, }); }); } } } });
<!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" /> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> <script>window.jQuery || document.write(decodeURIComponent('%3Cscript src="js/jquery.min.js"%3E%3C/script%3E'))</script> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/24.1.6/css/dx.light.css" /> <script src="js/dx.all.js"></script> <script src="data.js"></script> <link rel="stylesheet" type="text/css" href="styles.css" /> <script src="index.js"></script> </head> <body class="dx-viewport"> <div class="demo-container"> <div id="sales"></div> <div class="options"> <div class="caption">Options</div> <div class="option"> <div id="show-data-fields"></div> </div> <div class="option"> <div id="show-row-fields"></div> </div> <div class="option"> <div id="show-column-fields"></div> </div> <div class="option"> <div id="show-filter-fields"></div> </div> </div> </div> </body> </html>
#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; }
const sales = [{ 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', }];

In this demo, you can click the checkboxes below the JavaScript 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.