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