Pivot Sort Columns

[gisela]

Hi Telerik team,

is it possible ? See attached picture.
The columns are sorted alphabetic (L,M,S), i need the columns in the order S,M,L.

Thanks in advance
Gisela

[Kalin]

Hi Gisela,

If you just need to sort the columns in descending order, you will have to set the SortOrder property of the desired PropertyGroupDescription to Descending. For more details about the Sorting in the PivotGrid you can check the following article from our online help documentation:
http://www.telerik.com/help/silverlight/radpivotgrid-features-sorting.html

Hope this helps.

Regards,
Kalin
Telerik

[gisela]

Hi Kalin,

your proposal works not in all cases.
Example: Sizes = XXS, XS, S, M, L, XL

Both cases of the Sortorder property do not bring the desired result.

I need a Sortorder Property like "None", because i bind the radpivotgrid to the desired ordered list.

Thanks

Gisela

[Kalin]

Hello Gisela,

By default RadPivotGrid sorts the data ascending or descending. If you want to control the sorting, you can modify the type of items which you want to sort in order to include an additional property which will be the sorting key afterwards. You will need to implement CompareTo and Equals methods so you can compare the sort keys as required. I have prepared and attached a sample project which demonstrates the exact approach (the class MyProduct has SortKey property which defines the order).

Hope this helps.

Regards,
Kalin
Telerik

[gisela]

Hi Kalin,

it works.

Thank you very much

Gisela