Hello,I'm evaluating igPivotView and I would like to ask you a question.
Is there any possibility to adjust measure field settings at runtime, like in Microsoft Excel PivotTable (where this function is called Value Field Settings)?For each measure, the user should be able to modify aggregate function and numeric format.
Thank you, regards. Maria
Hello Maria,
There is no out of the box functionality to change "value field settings" in igPivotGrid, but this functionality can be achieved using the API.For example changing the "summary value" require the data source to be recreated with the new configuration.To change the format you need to handle the igGrid.rowsRendering event and modify the columns's format optionI'm attaching a sample to demonstrate both scenarios.
Hope this helps,Martin PavlovInfragistics, Inc.
Hi Martin,thank you. I'll use your suggestion to update cell format.
If I would like to format a number as "1.234,53" (italian settings, with "." as thousands separator and "," as decimal separator) which format should I specify?
Thanks again,Maria