Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
925
Measure field settings
posted

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

Parents
  • 23953
    Offline posted

    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 option
    I'm attaching a sample to demonstrate both scenarios.

    Hope this helps,
    Martin Pavlov
    Infragistics, Inc.

    igPivotGrid_format_runtime_measure.zip
Reply Children