Skip to main content
A newer version of this page is available. .
.NET Framework 4.5.2+
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