To select all items, click the checkbox next to (Select All). Select the checkboxes next to the items that you want to display in the report. In the PivotTable, click the dropdown arrow next to the report filter. In the Filter fields per column box, type or select the number of fields to display before taking up another column or row (based on the setting of Arrange fields you specified in the previous step). To display report filters in columns from left to right, select Over, Then Down. To display report filters in rows from top to bottom, select Down, Then Over. In Report Filter area, in the Arrange fields list box, do one of the following: In the Layout tab, specify these options: Right-click anywhere in the PivotTable, and then click PivotTable Options. The order of the report filters will be reflected accordingly in the PivotTable.ĭisplay report filters in rows or columnsĬlick the PivotTable or the associated PivotTable of a PivotChart. To change the order of the fields, in the Filters area, you can either drag the fields to the position that you want, or double-click on a field and select Move Up or Move Down. Report filters are displayed above the PivotTable for easy access. You can repeat this step to create more than one report filter. In the PivotTable Field List, click on the field in an area and select Move to Report Filter. If you want to display filter pages (the set of values that match the selected report filter items) on separate worksheets, you can specify that option. Items you select in the filter are displayed in the PivotTable, and items that are not selected will be hidden. To remove all filtering at once, click PivotTable Analyze tab > Clear > Clear Filters.īy using a report filter, you can quickly display a different set of values in the PivotTable. Click it to change or clear the filter by clicking Clear Filter From. The filtering arrow changes to this icon to indicate that a filter is applied. In the list of row or column labels, uncheck the (Select All) box at the top of the list, and then check the boxes of the items you want to show in your PivotTable. In the PivotTable, click the arrow on Row Labels or Column Labels. Turn filtering options on or off Filter data manually Use any of the following filtering features instead of or in addition to using slicers to show the exact data you want to analyze.įilter by selection to display or hide selected items only You can apply a slicer style or change settings using the various tab options. Tip: To change how the slicer looks, click the slicer to show the Slicer tab on the ribbon.