Filter a field in a PivotTable list

Filter a field in the row, column, filter, or detail area (Autofiltering)

  1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
  2. Click the arrow Field arrow for the field that contains the items of data that you want to filter.
  3. Select the check boxes for the items you want to display, and clear the check boxes for the items you want to hide.

Notes 

Display only data that matches a cell in a PivotTable list (Filter By Selection)

  1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
  2. Right-click the cell that contains the value you want to display, and then click Filter By Selection on the shortcut menu.

Filter a row or column field for top or bottom n values or a percentage (Conditional filtering)

  1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
  2. Select the field that has the values you want to filter.
  3. Click Commands and Options Field arrow on the toolbar, and then click the Filter and Group tab.
  4. Set Display the to Top or Bottom.
  5. Set Items to a number in the list, or type the value you want.
  6. To show n number of items, clear the % check box. To show n% of items, select the % check box.
  7. Set Based on to a value in the list.

Notes