Remove filters to display all data in a PivotTable list

When items in a field are hidden by filtering a field or filtering by selection, the arrow Field arrow in the field label is blue. When items are hidden by filtering for top or bottom values, the filtered field displays a funnel Funnel icon icon to the left of the arrow.

  1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
  2. Do one of the following:

    Remove all filters

    Note   If you click AutoFilter again to turn filtering back on, the previously set filters will be reapplied.

    Remove an autofilter or filter by selection from a field

    1. Click the blue arrow Filtered field arrow of the field from which you want to remove the filter.
    2. Select the (All) check box and click OK.

    Remove a conditional filter from a field

    1. Select the field from which you want to remove conditional filtering.
    2. Click Show Top/Bottom Items on the toolbar, and then click Show All.
Notes