Pivot Table-Setting the Number of Fields Displayed in the Page Layout in Microsoft Excel 2010

In this article we will learn how we can setting the number of fields displayed in the page layout- Pivot table.

You can manually set the number of fields to be displayed in the page layout in pivot table.
Let us take an example:

We have products report for five countries.

We have a pivot table report on five products & their sale figure in the five countries.

We need to limit the number of fields in FILTERS.
Right-click a cell in the pivot table, and click Pivot Table Options.

On the Layout & Format tab, the “Display Fields in Report Filter Area” is set for “Down, Then Over”

In the “Report filter fields per column” box, select the number of filters to go in each column. The default is zero which means "no limit".
If we set this limit to say 3

All the countries will be shown like the below shown snapshot.

Ron
August 26, 2013 at 4:36 am

I need to use a pivot table as a data table in another program. How do I get the field headers to copy down so the info is on each line? thanks!

Reply ↓
Ron
August 26, 2013 at 4:34 am

I have set the number of fields to a larger number than I need (8), but am not permitted to add more than 4 for some reason. Advice?

Reply ↓

Leave a Reply Cancel reply

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.