PivotLayout Methods
Contains various options used to adjust the layout of the PivotTable report.
Name | Description |
---|---|
Hide |
Hides all subtotals in the Pivot |
Insert |
Inserts a blank row after each outer row field item in a pivot table. |
Remove |
Removes blank rows after items of the outer row fields in a pivot table. |
Repeat |
Specifies whether to repeat item labels for all outer row and column fields in a pivot table. |
Set |
Applies the specified report layout to a pivot table. |
Show |
Displays all subtotals in the Pivot |
See Also