Filter a field to display only the data you want

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

  1. Click the arrow Field arrow for the field that contains the items of data that you want to filter.
  2. 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 (Filter by selection)

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

  1. Select the field that has the values you want to filter.
  2. Click Commands and Options on the PivotTable list toolbar, and then click the Filter and Group tab.
  3. Set Display the to Top or Bottom.
  4. Set Items to a number in the list, or type the value you want.
  5. To show n number of items, clear the % check box. To show n% of items, select the % check box.
  6. Set Based on to a value in the list.

Notes