![]() To do that, select a row field and on the PivotTable Tools | Analyze tab, in the Active Field group, click the Field Settings button. You can change the layout options for the specific row fields only. To invoke it, click the PivotTable Options button in the PivotTable group. The advanced layout options can be specified using the Layout & Format tab of the PivotTable Options dialog. To do that, on the PivotTable Tools | Layout tab, in the Layout group, click the Subtotals, Grand Totals or Blank Rows button, respectively, and select the desired action from the drop-down menu. You can also specify whether to show/hide subtotals and grand totals in the PivotTable report, or insert the blank line after each item in the outer row fields. To disable repeating, select Do Not Repeat Item Labels. To do that, select the Repeat All Item Labels item in the Report Layout drop-down menu. For the outline and tabular forms, you can enable repeating item labels in the outer row fields.Tabular Form - the pivot table is shown in the table format. Outline Form - the report data is outlined. The report is compressed to prevent data from spreading horizontally off the screen. ![]() The invoked drop-down menu allows you to apply one of the following layout forms.Ĭompact Form - the default layout. To change the PivotTable layout, on the PivotTable Tools | Layout tab, in the Layout group, click the Report Layout button. This topic describes how to specify the layout options for the entire PivotTable report or a specific row field only.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |