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 dialog for the filter conditions. Alternatively, call up the context menu of the pivot table and select the Filter command. The Filter dialog 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 checkbox to show or hide the associated field member in the pivot table.
- Enable or disable the All checkbox 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 - LibreOffice 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.