Skip to main content
All docs
V25.1
  • DxPivotTable Methods

    A Pivot Table component for multi-dimensional data analysis and cross-tab reporting.
    Name Description
    BeginUpdate() Suspends Pivot Table updates caused by parameter changes and method calls until the EndUpdate() method is called.
    ClearFilter() Clears the filter applied to Pivot Table data.
    CollapseAllColumns() Collapses all columns in the Pivot Table component.
    CollapseAllGroups() Collapses all groups in the Pivot Table component.
    CollapseAllRows() Collapses all rows in the Pivot Table component.
    EndUpdate() Resumes Pivot Table updates (when the BeginUpdate() method pauses updates) and re-renders the Pivot Table.
    Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
    Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
    ExpandAllColumns() Expands all columns in the Pivot Table component.
    ExpandAllGroups() Expands all groups in the Pivot Table component.
    ExpandAllRows() Expands all rows in the Pivot Table component.
    GetFields() Returns a collection of Pivot Table fields.
    GetFilterCriteria() Returns the filter criteria applied to Pivot Table data.
    GetHashCode() Serves as the default hash function. Inherited from Object.
    GetType() Gets the Type of the current instance. Inherited from Object.
    HideFieldList() Hides the Field List.
    LoadLayout(PivotTablePersistentLayout) Restores Pivot Table layout.
    MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
    ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
    Reload() Reloads Pivot Table data.
    SaveLayout() Returns Pivot Table layout information so you can save it to a variable or a custom storage.
    SetFieldPosition(String, PivotTableArea, Int32) Displays the field in the specified area and sets the field’s index.
    SetFilterCriteria(CriteriaOperator) Applies a filter to Pivot Table data.
    SetFilterCriteria(String) Applies a filter to Pivot Table data.
    ShowFieldList() Displays the Field List.
    ShowFieldList(DialogDisplayOptions) Displays the Field List and positions it based on specified display options.
    ToString() Returns a string that represents the current object. Inherited from Object.
    See Also