Is sorting flat data possible?

[Oscar]

Hello,

I'm using the PivotGrid control with local databinding (the local data might be different, it's some kind of dynamic data so not always there will be the same fields with the same names).

For example, I receive these records where the Year field is:
- 2012
- 2009
- 2010
- 2013
- 2011

But I would like that when I add this Year field to my pivot grid I could read the data like this:
- 2009
- 2010
- 2011
- 2012
- 2013

I have tried using the dataSource sort method, etc. but I cannot achieve this.

[Nikolay Rusev]

Hello Oscar,

I'm afraid that sorting is not yet supported.

Regards,
Nikolay Rusev
Telerik

 

 

[Rolf]

Hi Oscar

You can transform your data as an array and the sort it before you add it to the PivotGrid.

Best regards
Rolf