officefileapi-devexpress-dot-spreadsheet-dot-pivotlayout-dot-underscore-members.md
Contains various options used to adjust the layout of the PivotTable report.
| Name | Description |
|---|---|
| CompactNewFields | Gets or sets a value indicating whether new fields should have their PivotFieldLayout.Compact property set to true. |
| DataOnRows | Gets or sets a value indicating whether multiple data fields in a pivot table should be displayed in rows down the report. |
| IndentInCompactForm | Gets or sets the indent increment for items from different row fields when a pivot table is shown in compact form. |
| MergeTitles | Gets or sets a value indicating whether to merge and center cells containing item labels for the outer row and column fields, subtotal and grand total captions. |
| OutlineNewFields | Gets or sets a value indicating whether new fields should have their PivotFieldLayout.Outline property set to true. |
| PageOrder | Gets or sets the order in which multiple page fields are displayed in the PivotTable report filter area. |
| PageWrap | Gets or sets the number of page fields to display before starting another column or row based on the PivotLayout.PageOrder property value. |
| ShowColumnGrandTotals | Gets or sets a value indicating whether grand totals should be displayed for columns in the PivotTable report. |
| ShowRowGrandTotals | Gets or sets a value indicating whether grand totals should be displayed for rows in the PivotTable report. |
| SubtotalIncludeHiddenItems | Gets or sets a value indicating whether hidden page field items in a pivot table should be included in subtotals and grand totals. |
| Name | Description |
|---|---|
| HideAllSubtotals() | Hides all subtotals in the PivotTable report. |
| InsertBlankRows() | Inserts a blank row after each outer row field item in a pivot table. |
| RemoveBlankRows() | Removes blank rows after items of the outer row fields in a pivot table. |
| RepeatAllItemLabels(Boolean) | Specifies whether to repeat item labels for all outer row and column fields in a pivot table. |
| SetReportLayout(PivotReportLayout) | Applies the specified report layout to a pivot table. |
| ShowAllSubtotals(Boolean) | Displays all subtotals in the PivotTable report. |
See Also