Sorting row field by values in specific column field

Aspose.Cells Product Family
, ,
1

We want to know how to do below manual sort through Aspose – sorting row field by values in specific column field (here instead of sorting row field by grand total values we want to sort by values in second column field)

image.png (5.6 KB)

2

Please Let me know if you need sample application

3

@LakshmiAys,

Please create a sample standalone console application with your sample file(s), zip the project and files and post us, we will check it soon. Also provide your expected sorted pivot data via a sample (manually created in MS Excel) file for reference.

4

Attaching the sample application.AsposeExcelColumnFieldSortIssue.zip (5.5 MB)

5

@LakshmiAys,

I tried your code using your project and also played upon with some other APIs but I could not accomplish your desired task (as per your screenshot). I found data sorting for row field is always/by default done by Grand Total column and not by Values in selected column or any other column. I have logged a ticket with an id “CELLSNET-47811” for your issue. We will look into it soon. We will check if your sample code needs some tweak or evaluate it to try to support it.

Once we have an update on it, we will let you know.

6

Thanks for the quick response. Will wait to hear from you on your further analysis and a possible work around for this issue.

7

@LakshmiAys,
Sure, we will write back here soon to share our feedback.

8

@LakshmiAys,

Please note, sorting PivotField by Values in selected column/row is not supported in Aspose.Cells APIs for now. We will support it later on.

Once we have an update on it, we will let you know.