\<bookmark_value\>DataPilot function; filtering tables\</bookmark_value\>\<bookmark_value\>filtering;DataPilot tables\</bookmark_value\>\<bookmark_value\>filters;DataPilot tables\</bookmark_value\>

Filtering Pivot Tables

You can use filters to remove unwanted data from a DataPilot 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.

פתיחת קובץ עם דוגמה:

Please support us!