PivotLayout.DataOnRows Property
Gets or sets a value indicating whether multiple data fields in a pivot table should be displayed in rows down the report.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v19.1.Core.dll
Declaration
Property Value
| Type | Description |
|---|---|
| Boolean | true, to arrange multiple data fields as a row field; otherwise, false. The default value is false. |
Remarks
Use the DataOnRows property to specify the orientation of multiple data fields in a pivot table. By default, when you add two or more fields to the data area, they are displayed horizontally across the columns, as shown in the image below.
If the DataOnRows is set to true, multiple data fields are displayed vertically as the innermost row field.
To replace the default “Values” heading for multiple data fields, use the PivotViewOptions.DataCaption property.
Example
The example below demonstrates how to change the orientation of multiple data fields in a pivot table to display them going across columns. To do this, use the PivotLayout.DataOnRows property of the PivotTable layout object that is accessed from the PivotTable.Layout property.
Note
A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheet-pivot-table-api-t298650
Dim worksheet As Worksheet = workbook.Worksheets("Report2")
workbook.Worksheets.ActiveWorksheet = worksheet
' Access the pivot table by its name in the collection.
Dim pivotTable As PivotTable = worksheet.PivotTables("PivotTable1")
' Display value fields in separate columns.
pivotTable.Layout.DataOnRows = False
Related GitHub Examples
The following code snippets (auto-collected from DevExpress Examples) contain references to the DataOnRows 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.