Pivot Fields

Aspose.Cells Product Family
1

Hi,

I have a query with respect to getting all the columns in pivot table and set orientation, position for each and every pivoted column.

I tried to get this answered from the live chat but your representative told me to raise a ticket.

Overview\ questions:

1) wanted a render a pivot table in "Pivot" sheet based on data in "RawData" sheet

2) the pivot comes up but, couldn't set properties for few fields and mark it as selected so that data gets rendered accordingly

3) How to set the first row as the pivot columns?

4) I used 4.9.0.0 and trying to set orientation and position properties for a pivoted column, how to get specific column based on column name (Which would be the first row\ cell value in the sheet)

Please help!

Regards,

Pradeep

2

Hi,

1) Please see the documents in the section how you may create pivot table reports: http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/working-with-pivot-tables.html

2) Please create your desired pivot table in MS Excel and provide the excel file here, will check it soon.

3) You may use PivotField.DisplayName attribute.


Thank you.