Pivot table custom sort

Aspose.Cells Product Family
1

Hi

I need assistance sorting a column in an alphabetical order in a pivot data field.

node js

2

@Vishnu_Vijay,

See the document on formatting pivot tables with example code on how to sort pivot field for your reference. Also, see the sample code for your reference:
e.g.
Sample code:

.........
// Setting autosort options.
// Setting the field auto sort.
pivotField.IsAutoSort = true;

// Setting the field auto sort ascending order, false refers to descending order.
pivotField.IsAscendSort = true;
..........

Hope, this helps a bit.

3

Hi Amjad_Sahi ,

Thank You

4

@Vishnu_Vijay,

You are welcome.