How to improve loading and scrolling performance in PivotGrid?

23 Oct 20191 minute to read

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;
        }