PivotTable.Layout Property

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

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

PivotLayout Layout { get; }

VB.NET

ReadOnly Property Layout As PivotLayout

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.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Layout property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

wpf-spreadsheet-pivot-table-api-t314425/CS/SpreadsheetWPFPivotTableExamples/CodeExamples/PivotTableLayoutActions.cs#L19

// Hide grand totals for columns.
pivotTable.Layout.ShowColumnGrandTotals = false;
#endregion #ColumnGrandTotals

winforms-spreadsheet-pivot-table-api-t298650/CS/SpreadsheetPivotTableExamples/CodeExamples/PivotTableLayoutActions.cs#L19

// Hide grand totals for columns.
pivotTable.Layout.ShowColumnGrandTotals = false;
#endregion #ColumnGrandTotals

spreadsheet-pivot-table-api-examples-t501894/CS/SpreadsheetDocServerPivotAPI/CodeExamples/PivotTableLayoutActions.cs#L19

// Hide grand totals for columns.
pivotTable.Layout.ShowColumnGrandTotals = false;
#endregion #ColumnGrandTotals

VB.NET

wpf-spreadsheet-pivot-table-api-t314425/VB/SpreadsheetWPFPivotTableExamples/CodeExamples/PivotTableLayoutActions.vb#L20

            ' Hide grand totals for columns.
            pivotTable.Layout.ShowColumnGrandTotals = False
'            #End Region ' #ColumnGrandTotals

winforms-spreadsheet-pivot-table-api-t298650/VB/SpreadsheetPivotTableExamples/CodeExamples/PivotTableLayoutActions.vb#L20

            ' Hide grand totals for columns.
            pivotTable.Layout.ShowColumnGrandTotals = False
'            #End Region ' #ColumnGrandTotals

spreadsheet-pivot-table-api-examples-t501894/VB/SpreadsheetDocServerPivotAPI/CodeExamples/PivotTableLayoutActions.vb#L20

            ' Hide grand totals for columns.
            pivotTable.Layout.ShowColumnGrandTotals = False
'            #End Region ' #ColumnGrandTotals