Filter data in a pivot table

There are several filtering methods available for pivot tables:

–Using report filters.

–Using row and column filters.

The report filters define a data slice on the basis of which a pivot table is created. Filtering is performed on fields added to the Filters area in the Constructor of the pivot table. The cells for managing report filters are located above the pivot table:

Row and column filters are applied to an already generated pivot table when you want to hide or display individual rows or columns depending on the values they contain or according to a specified condition.

When you use the Compact layout, the sort and filter buttons are in cells with common row and column labels. The defaults are Row labels and Column labels (you can change the captions for the labels in the Options tab of the pivot table settings pane):

When you use the Tabular and Outline layouts, the filter buttons are located in the cells of the respective titles:

You cannot apply multiple filters to a single column or row in a pivot table at the same time. When a new filter is set, the old one is automatically reset.

Report filters and row or column conditional filters work together, but report filters have the highest priority, that is their results are taken into account when setting the filters by condition. The filtering by condition includes the columns and rows that are actually displayed in the pivot table after the report filters are applied.

Setting row and column filters, in turn, affects pivot table functions such as viewing data details and additional calculations: cell details tables and additional calculations are generated with the filters applied.