Welcome to the Angular feedback portal. We’re happy you’re here! If you have feedback on how to improve the Angular, we’d love to hear it!>
Thanks for joining our community and helping improve Syncfusion products!
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.