Back to Devexpress

PivotFieldLayout Properties

officefileapi-devexpress-dot-spreadsheet-dot-pivotfieldlayout-dot-underscore-properties.md

latest1.6 KB
Original Source

PivotFieldLayout Properties

Contains layout settings for a PivotTable field.

NameDescription
CompactGets or sets a value indicating whether item labels from the next row field should be displayed in the same column as the current row field.
InsertBlankRowAfterEachItemGets or sets a value indicating whether a blank row should be inserted after each item in the current row field.
OutlineGets or sets a value indicating whether items of the current row field should be shown in outline form.
RepeatItemLabelsGets or sets a value indicating whether item labels should be repeated in the current outer field.
ShowItemsWithNoDataGets or sets a value indicating whether field items that have no data should be displayed in the PivotTable report.
SubtotalOnTopGets or sets a value indicating whether subtotals for the field should be displayed on top.

See Also

PivotFieldLayout Interface

PivotFieldLayout Members

DevExpress.Spreadsheet Namespace