Sorting problem

Author	Message
Thomas Streitferdt	Thomas Streitferdt posted 10 Years Ago Topic Details
Group: Forum Members Posts: 3, Visits: 38	Hello, my x-Axis is sorting 0. 1. 10. 11. 12. 13. (...) 2. 3. 4. 5. ... . But I need 0. 1. 2. 3. (...) 10. 11. 12. 13. (...). I think it´s because of the format in my database [Text], which I can´t change. Is there any solution how I can get the sorting that I need? I hope you understand my problem! Thank you for your help. Thomas
	Reply Like 0
Nevron Support	Nevron Support posted 10 Years Ago Post Details
Group: Administrators Posts: 3.1K, Visits: 4.2K	If we understand correctly you have some numbers in a data table column, that are plotted as titles on the category axis (Primary X) and you want to sort them as numbers. If this is the case you can follow these instructions: 1. Create a category grouping with the following grouping expression: =Fields!YourTextField 2. Create a sorting rule for the category grouping with the following expression: =TONUM(FIRST(Fields!YourTextField)) This should sort the category data groupings in ascending order and treat the strings as numbers. Best Regards, Nevron Support Team
	Reply Like 0