Enable Display next field in the same column

Aspose.Cells Product Family
1

Hi,
I want to display Second pivot Row under the first row. I mean, i just want to display all columns as a single column

Manual process to do this

Pivot Table
--> Field Settings
--> Lay out & print
--> Show item labels in outline form
Enable -> Display next field in the same column


Currently its not available on the aspose at 2009. is it possible to do that now?

Thanks
Rahadian
2

Hi Rahadian,


Thank you for contacting Aspose support.

I believe you wish to change the layout of the Pivot Table to Compact Form. If I am correct in my understanding, you can achieve this using the PivotTable.ShowInCompactForm method. Please note, you have to refresh and calculate the Pivot Table after changing the layout.

In case this is not what you are looking for then please share the sample spreadsheet containing the Pivot Table that you wish to manipulate with Aspose.Cells APIs and your desired results that you may create manually in Excel application.