.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

PivotField.Layout Property

Provides access to settings used to adjust the layout of the PivotField object.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v21.2.Core.dll

Declaration

PivotFieldLayout Layout { get; }

Property Value

Type Description
PivotFieldLayout

A PivotFieldLayout object containing layout settings for a pivot field.

Remarks

Use the Layout property to get access to the PivotFieldLayout object, which allows you to adjust the layout of the row and column fields in the PivotTable report. In particular, you can show an outer row field in outline, compact or tabular form (PivotFieldLayout.Outline, PivotFieldLayout.Compact), insert a blank line after each item of an outer row field (PivotFieldLayout.InsertBlankRowAfterEachItem), specify the subtotal location for an outer row field (PivotFieldLayout.SubtotalOnTop), repeat item labels for an outer row or column field (PivotFieldLayout.RepeatItemLabels), or display items that have no data in the report (PivotFieldLayout.ShowItemsWithNoData).

See Also