Did you know you can break up your PivotTable’s Report filters into multiple columns?
Take a normal PivotTable with multiple Report Filters (In this example – Region, Product Description, Business Segment, Customer Name).
Right click anywhere inside the PivotTable and select PivotTable options.
In the Options dialog box, you’ll see a setting called ‘Report filter fields per column’.
Change this setting to specify the number of filter fields you’d like to have in each column. In this example, I’d like break up my Report filters so that only two are showing in each column.
Once implemented, the Report filters are broken out so that only two show up in each column.
This is a nice feature if you want your Report filters conform to the general shape of your PivotTable.
Here is a PivotTable where the Report filters are set to show only one per column.