How to sort Row field data in descending order by data field in Pivot Table in .NET

Aspose.Cells Product Family
1

Hi Aspose support team,

i have the pivot table with one row field, one column field and two data fields. The row field should be sorted in descending order of data field1. please find the attached screenshot for your kind reference. How to achive this feature? Thanks in advance.

Regards,

Saravanan.

2

Hi,

I think you may try some attribute for your pivot fields, e.g

pivotTable.RowFields[0].IsAutoSort = true;//Set auto-sorting on
pivotTable.RowFields[0].IsAscendSort = false;//Descending.
pivotTable.RowFields[0].AutoSortField = 0;//By first data field

For reference, see the documents in the section:
Using Pivot Tables


Thank you.