PivotLayout Methods
Contains various options used to adjust the layout of the PivotTable report.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