Show / Hide Table of Contents

Invoke a Filter Popup Window

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

Invoke a Filter Window from the Pivot Table

Field headers display special buttons used to invoke a Filter Window. Follow the steps below:

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

    EU_XtraPivotGrid_Filter_HoverFieldHeader

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

    EU_XtraPivotGrid_Filter_FilterList

Invoke a 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 Filter Window, click the filter button displayed in the field header.

EU_XtraPivotGrid_FieldListFiltering

In This Article
Back to top Copyright (c) 2006-2023 EarthCape OY. All rights reserved.