Changing the Layout of Pivot Table
Contents
[
Hide
]
How to Change the Layout of Pivot Table in MS-Excel
Microsoft Excel allows you to change the Layout of Pivot Table using PivotTable Tools > Design > Report Layout menu commands. You can change the Layout in these three forms
- Show in Compact Form
- Show in Outline Form
- Show in Tabular Form
How to Change the Layout of Pivot Table Using Aspose.Cells for Python Excel Library
Aspose.Cells for Python excel library also provides PivotTable.show_in_compact_form(), PivotTable.show_in_outline_form() and PivotTable.show_in_tabular_form() methods to change the layout of pivot table in these three forms.
Sample Code
The following sample code first shows the Pivot Table in Compact Form, then it shows the Pivot Table in Outline Form and lastly it shows Pivot Table in Tabular Form.