Sort a list of numbers by their (positive) numerical value, i.e. -123 as 123

[#1]

I have made a pivot table where I need to sort a list of negative and positive numbers by their (positive) numerical values, i.e. -123 is sorted as 123, but still retains its original vale of -123

To further elaborate I may add provide the following list of values and the way they are sorted:

Natural list: -250, -123, -10, 0, 9, 122, 249

Sorted list: 0, 9, -10, 122, -123, 249, -250

Assistance is appreciated

Peter Hove

[hector · Accepted solution]

Hi, if you use fabs(field) ascending and order by expresion??

rgds

[#3]

Thanks - it did solve the problem!