Free Support Forum - aspose.com

How can i transpose pivot data

i have writen the code to gives me a pivot shown in ebere.xlsx but i need to be like signoff.xlsx. i found out that if a drag the summation value in the row field to colum field it gives me that , but how do i do that with code. thanks. if this is solved i will be able to convince my company to get aspose cos it is wonderful . just stumbled upon it 3days ago, never seem file format application so flexible like aspose for developers

Hi,


I think you may drag pivot filed to other area.
See some sample line of code, e.g
pivotTable.AddFieldToArea(PivotFieldType.Column, pivotTable.DataField);


Thank you.