I have a scenario in my web application where I need possibility to sort values in RadPivotGrid by field existing in datasource, but is not displayed in RadPivotGrid. For Example I have flats that should be sorted in order defined in field sort_order, I can add this field to RadPivotGrid, but I don't want to show it to user. This approach works perfectly with standard RadGrid, but unfortunately does not work with RadPivotGrid. Flats are sorted by their names, with is wrong from my point of view.
Hello Marcin, If you set your "Powstańców 25 A/1" as "Powstańców 25 A/01" till "A/10", i believe your sort problem will be fixed.
I forgot to describe attached file. In grid you can see field with value "Powstańców 25 A/1" next is "Powstańców 25 A/10" but this order is wrong. Between this two values should be displayed values: Powstańców 25 A/2, Powstańców 25 A/3, Powstańców 25 A/4, etc...