Arranging filters in a pivot table

In one of the previous posts, there was a general mention of pivot table options, and in the next few “recipes” we will address some of them that are important and can make our daily work easier. Filtering the pivot table is achieved by dragging report dimensions into the Filters field. How can we influence the number and layout of available filters in the pivot table?

Open the pivot table Options by clicking on the button/menu of the same name found in the Analyze ribbon, after which a new window will open with many options, grouped by tabs. The Layout & Format tab contains the ones we can use to edit the filters in the pivot table. The Display fields in report filter area drop-down list provides us with two choices: Down, then over and Over, Then Down. The Report filter fields per column selector lets you choose how many filters you want to provide for a row or column. The default value is 0, which means there are no limits. If we state, for example, number 3, then, after displaying three filters, new filters would start appearing in the next column (provided that Down, then over is selected). By further adjusting, we arrange the number and schedule of filter views in the report.