Skip to main content
Row

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