Controlling the Visibility of Fields

The following operations allow end-users to change the visibility of a field:

Action	Effect
Selecting the “Hide” item in the field header context menu.	Hides the field. The “Hide” item is disabled when the pivot grid’s OptionsCustomize.Hiding property is set to False.
Selecting the “Show Field List” item of the field header context menu.	Invokes the customization form.
Dragging a field header and dropping it outside any header area.	This action can be performed only when the field’s Options.Moving option is on and the customization form is visible. The result is dependant upon the pivot grid’s OptionsCustomize.Hiding property’s value: if the property is set to True, the field is hidden. if the property is set to False, the field is not hidden.
Dragging a field header from the customization form to a specific area within the pivot grid control.	Shows the field header in the specified area and modifies the pivot grid’s layout which is dependant upon the positions of fields.
Double-clicking a field header within the customization form or selecting a field header and clicking the form’s Add To button.	Shows the field in the specified area.

Note

If a field’s Hidden option is disabled, this field is not displayed within the customization form.