PivotLayout Members
In This Article
#Properties
Name | Description |
---|---|
Compact |
Gets or sets a value indicating whether new fields should have their Pivot |
Data |
Gets or sets a value indicating whether multiple data fields in a pivot table should be displayed in rows down the report. |
Indent |
Gets or sets the indent increment for items from different row fields when a pivot table is shown in compact form. |
Merge |
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. |
Outline |
Gets or sets a value indicating whether new fields should have their Pivot |
Page |
Gets or sets the order in which multiple page fields are displayed in the Pivot |
Page |
Gets or sets the number of page fields to display before starting another column or row based on the Pivot |
Show |
Gets or sets a value indicating whether grand totals should be displayed for columns in the Pivot |
Show |
Gets or sets a value indicating whether grand totals should be displayed for rows in the Pivot |
Subtotal |
Gets or sets a value indicating whether hidden page field items in a pivot table should be included in subtotals and grand totals. |
#Methods
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