i have a Problem regarding to a sorting of positiv and negativ values. My Dimension is 'Name' and the field where i like to sort the values is called 'VALUES'. This field values includes for example -1000, 25000, -256, 5000 etc.
What i want is a sort of the highest varitations of the vaules from the 0 Point. For example
The requirement is to sort the top 3 varitations. In this case is the solution is ...
1. E / -80000
2. G / 12000
3: D / -10000
In the moment i am sorting of the field VALUE with numeric value desc. But this don´t give me my solution which i Need.