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!
Hello,
I am encountering another minor issue when using the Defer Layout Update setting in the pivot grid. I am attempting to change the default aggregate function for a numeric field to "Average" instead of "Sum" when it is dropped onto the Value axis. I am subscribing to the onFieldDropped event of the Pivot Field List and changing the type of the args.droppedField to "Avg". This works correctly when not using the Defer Layout Update. However, when this feature of the Pivot Grid is turned on, the UI does not update and still shows the original aggregate type (Sum). However when applying the field list settings, the average does indeed show in the grid. Is there a way to refresh the UI? I tried calling the refresh() method of the field list object, but this threw an error and the popup went away.
I have a StackBlitz example here:
https://stackblitz.com/edit/angular-k3g1iy-brjqbu?file=app.component.html
To reproduce, click the field list icon, drag "Year" to the Rows axis, and then "Sold" to the Values axis. The text "Sum of Sold" is shown in the UI, but clicking Apply shows the average value of the field in the grid.