Allow multiple filters per field

If you run the Pivot table options (Analyze/Options), in the Totals & Filters section, you will find the Allow multiple filters per field setting. It allows you to apply text filters and number filters simultaneously for the reporting dimension, which can be displayed in rows or columns. This feature could be useful, let’s see how it works!

First off all, let’s activate this option. Create a Pivot table, select it, then go to the Analyze ribbon and click the Options button. When the window opens go to the Totals & Filters tab and check Allow multiple filters per field there, then close the window.

The rows of the report contain the names of the items, and in the values section there is a sum of the quantities sold. Let’s put a text filter (Label Filters) so that the item in the name has the word “JABUKA” (APPLE). Then let’s go to the Number Filters and select the criterion for displaying the top five products (Top 5). Both filters will be accepted by the report.