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

    An interface that defines the DxPivotTable component’s API members (properties and methods).
    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.
    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.
    HideFieldList() Hides the Field List.
    LoadLayout(PivotTablePersistentLayout) Restores the Pivot Table layout.
    Reload() Reloads Pivot Table data.
    SaveLayout() Saves information about the Pivot Table layout.
    SetFieldPosition(String, PivotTableArea, Int32) Positions the field at the specified area, 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.
    See Also