[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
   Reporting
  [Expand]Data Grid
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Collapse]Layout
     Field Groups
     Data Cell Layout
     Field Location and Order
    [Collapse]Customization Form
      Customization Form Overview
      Customization Form Styles
      Standalone Customization Control
      User Folders
     Best Fit
     Standalone Field Header Areas
     Group Value
     Save and Restore Layout
   [Expand]Printing and Exporting
   [Expand]End-User Interaction
   [Expand]Appearance
   [Expand]MVVM Enhancements
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Examples
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Gantt Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Customization Form Overview

The Customization Form allows end users to add and remove fields from a pivot grid at runtime. They can also use it to rearrange fields in pivot grid areas, sort and filter data.

Expanded Availability

Use the PivotGridControl.AllowCustomizationForm property to specify whether end users are allowed to invoke the Customization Form.

Expanded Invoke the Customization Form

An end user can invoke the Customization Form from the header area context menu. To do this in code, use the PivotGridControl.ShowFieldList method. The PivotGridControl.HideFieldList method allows you to hide the Customization Form.

After the Customization Form is invoked or closed, PivotGridControl raises the PivotGridControl.ShownFieldList or PivotGridControl.HiddenFieldList event, respectively.

Expanded Hide Fields

To hide a field from the pivot grid, drag its header and drop it within the Customization Form's client area. When end users move fields to the Customization Form, the field's visibility is changed, but the field's area remains unchanged. To return the field to the pivot grid, drag its header from the Customization Form to a pivot grid's header area (e.g., Data Header Area, Row Header Area).

Use the PivotGridControl.AllowHideFields property to specify whether fields can be dropped onto the Customization Form, and the PivotGridControl.AllowDragInCustomizationForm property (or PivotGridField.AllowDragInCustomizationForm for individual fields) to specify whether fields can be dragged out of the Customization Form or between its sections.

You can prevent a field from appearing within the Customization Form when the field is hidden. To do this, set the PivotGridField.ShowInCustomizationForm property to false.

Expanded Display Visible Fields in the Customization Form

You can also display visible fields together with hidden ones. In this instance, a check box is shown near each field allowing you to show or hide this field.

To specify whether visible fields are shown in the Customization Form, use the PivotGridControl.FieldListIncludeVisibleFields property.

Expanded Advanced Capabilities

To learn about advanced Customization Form capabilities, see the following topics.

Is this topic helpful?​​​​​​​