How to hide defer layout update and show calculations as columns options in the pivot table field list in WinForms PivotGridControl?

Hiding the defer layout update options

You can hide the update check box and update button of the defer layout by using the DeferLayoutUpdateCheckBox and DeferLayoutUpdateButton properties in the pivot schema designer.

Refer to the following code sample to hide the defer layout options in the pivot table field list.

C#

this.pivotGridControl1.PivotSchemaDesigner.DeferLayoutUpdateButton.Visible = false;
this.pivotGridControl1.PivotSchemaDesigner.DeferLayoutUpdateCheckBox.Visible = false;

VB

Me.pivotGridControl1.PivotSchemaDesigner.DeferLayoutUpdateButton.Visible = False
Me.pivotGridControl1.PivotSchemaDesigner.DeferLayoutUpdateCheckBox.Visible = False

Pivot grid without displaying defer layout update options in pivot table field list

Hiding the show calculations as columns option

You can hide the show calculations as columns check box by using the ShowCalculationsAsColumnCheckBox property in the pivot schema designer.

Refer to the following code sample to hide the show calculations as columns option in the pivot table field list.

C#

this.pivotGridControl1.PivotSchemaDesigner.ShowCalculationsAsColumnCheckBox.Visible = false;

VB

Me.pivotGridControl1.PivotSchemaDesigner.ShowCalculationsAsColumnCheckBox.Visible = False

Pivot grid without displaying show calculations as columns option in pivot table field list