Hi, Im trying to use the "PivotView" component of the syncfusion angular suite, but i'm having some problems regarding the "values" dimension. after configuring the "PivotView" whenever i try to add any field to this dimension the component just throws a error on the console.
bellow is the error thrown in the console and i've atached a image with the array sample.
CONSOLE ERROR:Error: format.split is not a function at Object.customFormat (https://localhost:44374/Spa/default~data-analysis-data-analysis-module~kanban-kanban-module.js:26780:34) at Function.push../node_modules/@syncfusion/ej2-base/src/intl/number-parser.js.NumberParser.numberParser (https://localhost:44374/Spa/default~data-analysis-data-analysis-module~kanban-kanban-module.js:27503:132) at Internationalization.push../node_modules/@syncfusion/ej2-base/src/internationalization.js.Internationalization.getNumberParser (https://localhost:44374/Spa/default~data-analysis-data-analysis-module~kanban-kanban-module.js:25056:81) at ValueFormatter.push../node_modules/@syncfusion/ej2-grids/src/grid/services/value-formatter.js.ValueFormatter.getParserFunction (https://localhost:44374/Spa/data-analysis-data-analysis-module.js:140341:30) at new Column (https://localhost:44374/Spa/data-analysis-data-analysis-module.js:125186:43) at prepareColumns (https://localhost:44374/Spa/data-analysis-data-analysis-module.js:121017:26) at Grid.push../node_modules/@syncfusion/ej2-grids/src/grid/base/grid.js.Grid.updateColumnObject (https://localhost:44374/Spa/data-analysis-data-analysis-module.js:119363:69) at Grid.push../node_modules/@syncfusion/ej2-grids/src/grid/base/grid.js.Grid.refreshColumns (https://localhost:44374/Spa/data-analysis-data-analysis-module.js:119416:18) at Render.push../node_modules/@syncfusion/ej2-pivotview/src/pivotview/renderer/render.js.Render.render (https://localhost:44374/Spa/data-analysis-data-analysis-module.js:220336:30) at PivotViewComponent.push../node_modules/@syncfusion/ej2-pivotview/src/pivotview/base/pivotview.js.PivotView.renderPivotGrid (https://localhost:44374/Spa/data-analysis-data-analysis-module.js:214550:31)Json Configuration
_this.csvReport = { dataSource: result, type: 'CSV', expandAll: false, enableSorting: true, drilledMembers: [], rows: [ { name: 'FABRICANTE_PRODUTO' }, { name: 'PRODUTO' } ], columns: [ { name: 'CLASSE_PRODUTO' }, { name: 'GRUPO_PRODUTO' } ], values: [{ name: 'VENDA_LIQUIDA' }, ], filters: [] };Html Configuration
#pivotview id='PivotView' [dataSourceSettings]='csvReport' height='300' [gridSettings]='gridSettings' showFieldList='true' width='100%' [displayOption]='displayOption' [toolbar]='toolbarOptions' enableVirtualization='true'
note: removed the
ejs-pivotview tags surrunding the html example because they were causing issues on the feedback portal editor.
i've atached a file with 3 prints