This is a migrated thread and some comments may be shown as answers.

Sorting in PivotGrid

4 Answers 44 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Mohan
Top achievements
Rank 1
Mohan asked on 02 Apr 2019, 08:01 AM

Hello Team,

 

Am expecting PivotGrid to display value into following order 1, 2, 12 and then 1011 but PivotGrid is displaying them into 1, 1011, 12 and then 2.

How can this be fixed?

 

Thanks,

Mohan

 

4 Answers, 1 is accepted

Sort by
0
Attila Antal
Telerik team
answered on 05 Apr 2019, 07:05 AM
Hi Mohan,

What I can think of is that the DataType for that field coming from the DataSource may not be numeric (integer, decimal, etc...) and that is why it is being treated as string. In addition to that, you may try defining the  DataFormString property for row field and make it number. Have you tried that one?

Kind regards,
Attila Antal
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
Mohan
Top achievements
Rank 1
answered on 02 May 2019, 05:37 AM
Yes, data type for column was string  which was causing issue.
0
Mohan
Top achievements
Rank 1
answered on 15 May 2019, 11:09 AM
Yes it helps. thanks.
0
Attila Antal
Telerik team
answered on 15 May 2019, 11:46 AM
Hi Mohan,

Thank you for sharing your feedback, I am glad to hear the suggestion was helpful!

Kind regards,
Attila Antal
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
PivotGrid
Asked by
Mohan
Top achievements
Rank 1
Answers by
Attila Antal
Telerik team
Mohan
Top achievements
Rank 1
Share this question
or