[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Collapse]Office File API
  Demo Application
  Redistribution and Deployment
 [Collapse]Spreadsheet Document API
   Product Structure
   Getting Started
  [Expand]Spreadsheet Document
   Supported Formats
  [Expand]Cell Basics
  [Expand]Formulas
   Defined Names
   Data Binding
  [Expand]Pivot Tables
  [Expand]Charts and Graphics
  [Expand]Mail Merge
  [Collapse]Examples
   [Expand]Files
   [Expand]Workbooks
   [Expand]Worksheets
   [Expand]Rows and Columns
   [Expand]Cells
   [Expand]Formulas
   [Expand]Import and Export Data
   [Expand]Data Binding
    Sorting
   [Expand]Mail Merge
    Search
   [Expand]Shapes
   [Expand]Charts
   [Expand]Sparklines
   [Expand]Formatting Cells
   [Expand]Conditional Formatting
   [Expand]Group Data
   [Expand]Filter Data
   [Expand]Tables
   [Collapse]Pivot Tables
     How to: Create a Pivot Table
     How to: Refresh a Pivot Table
     How to: Change a Data Source for a Pivot Table
     How to: Move a Pivot Table
     How to: Clear or Remove a Pivot Table
     How to: Change the PivotTable Layout
     How to: Subtotal Fields in a Pivot Table
     How to: Display or Hide Grand Totals for a Pivot Table
     How to: Format Numbers and Dates in a Pivot Table
     How to: Apply a Predefined Style to a Pivot Table
     How to: Apply a Custom Style to a Pivot Table
     How to: Control Style Options
     How to: Change the Summary Function for a Data Field
     How to: Apply a Custom Calculation to a Data Field
     How to: Create a Calculated Field
     How to: Create a Calculated Item
     How to: Sort Items in a Pivot Table
     How to: Filter Items in a Pivot Table
     How to: Group Items in a Pivot Table
   [Expand]Printing
   [Expand]Pictures
   [Expand]Protection
 [Expand]Word Processing Document API
 [Expand]PDF Document API
 [Expand]Excel Export Library
 [Expand]Snap Report API
 [Expand]Zip Compression and Archive API
 [Expand]Barcode Generation API
 [Expand]Unit Conversion API
 [Expand]API Reference
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

How to: Change the PivotTable Layout

To change the layout form of a PivotTable report, pass the appropriate PivotReportLayout enumeration member to the PivotLayout.SetReportLayout method.

The table below describes the available report layouts and lists additional options that can be set for each layout form.

Layout Form

Description

Additional Layout Options

Compact Form

(PivotReportLayout.Compact)

This is the default layout for a newly created PivotTable report. This layout enables you to keep your report as narrow as possible.

It displays items from different row fields in a single column and subsidiary row field items are shown indented to the left.

Outline Form

(PivotReportLayout.Outline)

This layout displays each row field in its own column. Subsidiary row field items begin one row below the parent field item.

Tabular Form

(PivotReportLayout.Tabular)

This layout displays each row field in its own column. Subsidiary row field items begin on the same row.

Subtotals for items in the outer row fields are always shown at the bottom.

The following code example shows how to change the default PivotTable layout to outline form.

Note

Besides changing the layout of the entire pivot table, you can also change the layout of a specific field in the report. To do this, use the corresponding properties of the PivotFieldLayout object, which can be accessed using the field's PivotField.Layout property.

Is this topic helpful?​​​​​​​