3 Replies Latest reply: Feb 2, 2015 6:21 AM by Sunny Talwar RSS

    Sort of positiv and negativ values

    Hans Müller

      Hi,

       

      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

       

      Name/Value

      A/1000

      B/500

      c/5

      D/-10000

      E/-80000

      F/9000

      G/12000

       

      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.

       

      Thanks...