In the pivot table I have created, I’m using a column containing two values. This way I split up my total.
The result looks something like this (extract showing the column area)
In Excel the columns are in reverse order, which is the way I want it. I’ve tried setting different column sorting, but none of the settings has any effect.
How do I change the column order?
Well, Aspose.Cells for .NET creates the pivot table similar to what MS Excel does. Could you create a sample template file containing the pivot table manually in MS Excel to show how your pivot table should be.
Also provide your sample code with template file using Aspose.Cells for .NET to show how the component is rendering the pivot table report.
We will check it soon. By the way, did you try the latest version 4.8.1.x: http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/entry207989.aspx
if not, kindly try it first.