How to improve loading and scrolling performance in PivotGrid?

The performance of the PivotGrid control can be improved by enabling the on-demand calculation on the value cells and by disabling the auto-sizing option. This refreshes the calculation only while loading or scrolling the PivotGrid control. This can be achieved by using EnableOnDemandCalculations and AutoSizeOption properties of PivotGrid control.

Please refer the below code snippet.

  • c#
  • public MainWindow()
            {
                InitializeComponent();
                pivotGrid.AutoSizeOption = GridAutoSizeOption.None;
                pivotGrid.PivotEngine.EnableOnDemandCalculations = true;
            }