Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, if you use fabs(field) ascending and order by expresion??
rgds
Thanks - it did solve the problem!