Pivot Table Multiple columns into single column

Aspose.Cells Product Family
1

Hi,
I want to display PivotFieldType.Row s data into single column is it possible through Aspose.Cells
Please give me the sample code for that.

pivotTable.AddFieldToArea(PivotFieldType.Row, 10);
pivotTable.AddFieldToArea(PivotFieldType.Row, 9);
pivotTable.AddFieldToArea(PivotFieldType.Row, 8);
pivotTable.AddFieldToArea(PivotFieldType.Row, 6);

i just want to display all three 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
Enable -> Display sub total at top of the each group
Thanks
Vissu

2

Hi,

Thank you for considering Aspose.

Well, I am afraid this feature is not supported by Aspose.Cells.

Sorry for the inconvenience,