#1 #10 #2 #3
I am viewing a report by category and the names are ML1 ML2 and so on and the result is ML1 ML10 ML2 ML3. How do correct this?
It is sorting properly as text. If you want it to sort as:
ML1 ML2, ML3 etc instead of ML1, ML10, you must create a calculation (type is number) and sort by this calc instead. Only put your category field in the calculation result. Because the calculation is number, it will ignore the alpha and sort propery as number.
Retrieving data ...