Ordering the Column values in Pivot table using aspose.cells

Aspose.Cells Product Family
1

Hi ,

Is there a function or anything through which we can order the column Values in the pivot

For example , there is a column AGE GROUP with data as
20-30 , 30-40,40-50 , Greater than 50

When we use the same column as the Column while creating the Pivot table , the values will become the columns of the pivot table now as shown in the below screenshot

image-20230510-113926.png (24.0 KB)

In the above screenshot, if you observe the values are in a random order

But is there a way to order them so that , 20-30 … 30-40 … 40-60 … Greater than 60 order will be maintained ??

The expected result should look like this below

image-20230510-114025.png (24.6 KB)

Need some Help on this ,
Thanks

2

@Veerendra1234,

Thanks for the screenshots.

Could you please create a sample Excel file with your desired sorting order for column field in the pivot table via PivotTable options in MS Excel manually, save the Excel file and provide us here (with steps details), we will check and help you soon.