Filtering Pivot Tables

You can use filters to remove unwanted data from a pivot table.

Click the Filter button in the sheet to call up the dialogue box for the filter conditions. Alternatively, call up the context menu of the pivot table and select the Filter command. The Filter dialogue box appears. Here you can filter the pivot table.

You can also click the arrow on a button in the pivot table to show a pop-up window. In this pop-up window, you can edit the visibility settings of the associated field.

• The pop-up window displays a list of field members associated with that field. A check box is placed to the left of each field member name. When a field has an alternative display name that differs from its original name, that name is displayed in the list.
• Enable or disable a check box to show or hide the associated field member in the pivot table.
• Enable or disable the All check box to show all or none of the field members.
• Select a field member in the pop-up window and click the Show only the current item button to show only the selected field member. All other field members are hidden in the pivot table.
• Select a field member in the pop-up window and click the Hide only the current item button to hide only the selected field member. All other field members are shown in the pivot table.
• Commands enable you to sort the field members in ascending order, descending order, or using a custom sort list.
• To edit the custom sort lists, open Tools - Options - Office Calc - Sort Lists.
• The arrow to open the pop-up window is normally black. When the field contains one or more hidden field members, the arrow is blue and displays a tiny square at its lower-right corner.
• You can also open the pop-up window by positioning the cell cursor at the button and pressing Ctrl+D.

Open file with example:

Related Topics

• Pivot Table
• Creating Pivot Tables
• Editing Pivot Tables
• Formatting Pivot Tables
• Updating Pivot Tables
• Grouping Pivot Tables
• Selecting Pivot Table Output Ranges
• Deleting Pivot Tables
• Pivot Chart