Pivot field List - sort the field names

[hamish]

In the RadPivotFieldList the fields appear in the order in which it finds them in the underlying Data source. I would like the fields to appear in alphabetical order - is there anyway to do that ? (i.e. sort by field name etc.). I do not mean sorting the data (I can see how that is done), I just want the fields to appear in the field list in alphabetical order

Thanks

[Polya]

Hi Hamish,

Unfortunately, the extraction of items for the RadPivotFieldList (LabelFilter) is done internally and no ordering is applied to the results in any way - they are ordered in the way they are received.
I have created a feature request for this functionality which you can find here. You can track its status and vote to raise its priority and if it receives enough client demand we will consider implementing this feature.

Regards,
Polya
Telerik

 

 

[Brett]

Hi Polya -

I would also like the ability to sort the fields in the RadPivotFieldList by a particular order. Is this still impossible? I attempted to apply the Order Data Annotation (https://msdn.microsoft.com/en-us/library/system.componentmodel.dataannotations.displayattribute.order(v=vs.110).aspx) but that had no effect.

Thanks,
Brett

[Polya]

Hello Brett,

If you are using the LocalDataSourceProvider as your data provider you can add handler to the LocalDataSourceProvider.FieldDescriptionsProvider.GetDescriptionsDataAsyncCompleted event and in its handler reorder the field infos in the desired way. You can find more information about this event in our help article: http://docs.telerik.com/devtools/wpf/controls/radpivotgrid/events/overview#dataprovider-events

I've prepared a sample project demonstrating how to order the fields by caption. You can find it attached.
Hope this helps.

Regards,
Polya
Telerik