We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Pivottable sorting issue

I must disable autosort property in pivot table.(

pivotTable.RowFields[pivotTable.RowFields.Count - 1].IsAutoSort =false;

)

But data provided to pivot table is in sorted order.

But my pivot table(sample data) is as follows

AGEGROUP(25-29)
CAMEL (BLUE) KS BOX 20 (-)
CAMEL KS BOX 20 (-)
IMPERIAL CLASSIC RED KS BOX 19 (-)
KARELIA BLUE KS RCB 20 (-)
KENT HD (SILVER) KS RCB 20 (-)
MARLBORO (RED UPGRADE) KS BOX 20 (-)
MARLBORO FLAVOR PLUS KS SRP 20 (-)
WINSTON BLUE 100 BOX 20 SSL (-)
WINSTON BLUE KS BOX 10 (-)
AGEGROUP(30-35)
ASSOS INTERNATIONAL KS BOX 20 (-)
CAMEL KS BOX 20 (-)
IMPERIAL CLASSIC RED KS BOX 19 (-)
KARELIA BLUE KS RCB 20 (-)
KENT HD (SILVER) KS RCB 20 (-)
MARLBORO (RED UPGRADE) KS BOX 20 (-)
MARLBORO FLAVOR PLUS KS SRP 20 (-)
WINSTON BLUE 100 BOX 20 SSL (-)
WINSTON BLUE KS BOX 10 (-)
ASSOS INTERNATIONAL KS BOX 20 (-)
KARELIA SPECIAL 100 RCB 20 (-)
WINSTON BLUE 0 (-)
WINSTON RED 0 (-)

In Above Pivot table For Age group (30-35) row field, Data is not sorted.

Only that data in Agegroup(30-35) which match with Agegroup(25-29) is sorted first. Remaining data (Colored data) is sorted next.

But I want Age group (30-35) row field also to be sorted in ascending order.

Please provide solution to this problem.

THANKYOU

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please refer to your other thread for a reply.