Invoke a Summary Filter Window

To enable and configure filtering by cell values, use the Summary Filter Window.

You can invoke a Summary Filter Window from the Pivot Table or from a Field List (to learn about Field Lists, see Field List Overview).

Invoke a Summary Filter Window from the Pivot Table

Field headers located in the Data Area display special buttons used to invoke a Summary Filter Window. Follow the steps below.

  1. Hover over the header of a field whose data you need to filter. A filter button (EU_XtraPivotGrid_FilterButton) will be highlighted.

    EU_SummaryFilter_HoverOverHeader

  2. Click this filter button to display a Summary Filter Window.

    EU_SummaryFilter_InvokeFromHeader

Invoke a Summary Filter Window from a Field List

You can use an advanced Field List to filter field values.

EU_XtraPivotGrid_FieldListExcel

First, invoke a Field List. For information on how to do this, see Invoke a Field List.

To open a Summary Filter Window, click the filter button displayed in the field header.

EU_SummaryFilter_InvokeFromFieldList