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.
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.