Excel Pivot Table Layout. At the left in the layout group click the report layout command. Change the way item labels are displayed in a layout form.
You can also double click the row field in outline or. In the pivottable select a row field. Show in outline form the pivot table will change to the selected layout.
You can also double click the row field in outline or.
To change the layout of the pivot click on design layout layout section. It s primary purpose it to save horizontal space. If you look closely at the first column you ll notice that both the customer and product fields are included in the same column. Then move the page field into the row area above the existing row field.