4 Replies Latest reply: Sep 18, 2014 8:26 PM by Nathaniel Anderson RSS

    Sort values in a chart legend

      Hello togehter,
      i created a dimension with
      =
      IF(A >=1 and A<1.25,'iinteresting',

      if(A>=1.25 and A<2.25,'empty',

      if(A>=2.25 and A<3.25,'grandfather',

      if(A>=3.25 and A<=4,'nearly'))))
      My legend at the bar-chart shows the values at following order:
      * nearly
      * grandfather
      * interesting
      * empty
      But i want that the legend shows the values like my formula. So i write the formula in the formula field at the sort register. but this doesn't work.Can anyone help me please? Thanks!