2 Replies Latest reply: Jun 12, 2015 4:51 AM by Stefan Zehr RSS

    Sorting a calculated dimension

      Hello everyone,

       

      I have a bar graph with a calculated dimension like this:

       

      = if (budget <= 100, 'bis ' & 100, 

           if(budget > 100 and budget <= 200, 'bis ' & 200,

           ...

      )

       

      'bis' is the german word for 'up to'. The result is a diagram like this:

      sorting_question.PNG

      As you see, the calculated dimension (x-axis) is not in the correct order. Correct would be:

       

      bis 100

      bis 200

      bis 300

      bis 400

      ...

      bis 1000

      ...

       

      I can not sort by number or by alphabetical order, the results are always wrong. But how can I sort such a dimension with an expression?