Sorting problem

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

Author	Message
Thomas Streitferdt	Posted 9 Years Ago
Forum Newbie Group: Forum Members Last Active: 9 Years Ago 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 QUOTE
Nevron Support	Posted 9 Years Ago
Supreme Being Group: Forum Members Last Active: Last Week Posts: 3,054, Visits: 4,018	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 QUOTE

Sorting problem

Sorting problem

Similar Topics

Reading This Topic