Feature request - SortExpression

[Barbaros Saglamtimur]

Is it possible to add SortExpression property? Like;

<telerik:PivotGridRowField DataField="ITEMNAME" Caption="Ürün Adı" UniqueName="ITEMNAME" ZoneIndex="4" SortExpression="ItemId">
</telerik:PivotGridRowField>

and default sort for the PivotGrid does not function if it does not binded to a DataField property.
For example; I did not bind ItemId to a RowField but would like to have default sort on that field. I think we need something like AdditionalDataFieldNames property.

<SortExpressions>
    <telerik:PivotGridSortExpression FieldName="ItemId" SortOrder="Ascending" />
</SortExpressions>

You know, RadGrid has this functionality.

PS:Attached screen shot shows my problem.

TIA

[Antonio Stoilkov]

Hello, 

The desired functionality could not be achieved because in order to sort a particular field it should be included in the data. The reason behind this is because the RadPivotGrid engine calculates based on the supplied data.

All the best,
Antonio Stoilkov
the Telerik team

[David]

I also needed to customize the sort of the Row Header.  Since I could not connect a field that contained the right sort sequence to the Row Header DataField, I included the sort sequence as the beginning character in the Row Header Value, then removed the sort sequence during PivotGrid_CellDataBound.

        protected void MyPivotGrid_CellDataBound(object sender, Telerik.Web.UI.PivotGridCellDataBoundEventArgs e)
        {
            // Format RowHeader Cell (custom sort cheat by including sort number in Measure field)
            if (e.Cell is PivotGridRowHeaderCell)
            {
                PivotGridRowHeaderCell cell = e.Cell as PivotGridRowHeaderCell;
                cell.Text = cell.Text.Remove(0, 2);
            }
}