Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

PivotTable.Layout Property

Provides access to options used to adjust the PivotTable report layout.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

PivotLayout Layout { get; }

#Property Value

Type Description
PivotLayout

A PivotLayout object containing layout settings for a pivot table.

#Remarks

Use the Layout property to get access to the PivotLayout object, which allows you to adjust the PivotTable report layout by displaying the pivot table in compact, outline, or tabular form (PivotLayout.SetReportLayout), display or hide subtotals (PivotLayout.ShowAllSubtotals) and grand totals for rows (PivotLayout.ShowRowGrandTotals) and columns (PivotLayout.ShowColumnGrandTotals), insert a blank line after items of the outer row fields (PivotLayout.InsertBlankRows), etc.

For examples on how to modify the PivotTable layout, refer to the Pivot Table Examples section.

See Also