5 Replies Latest reply: Mar 3, 2016 3:44 AM by Raphael Blavier RSS

    How to refer to the dimension in sort expression ?

    Raphael Blavier

      Hello,

       

      I have created a bar chart with a calculated dimension.

      I want to manually sort that dimension with the expression :

      Sort Expression.png

      I add this formulae to the expression :

      =if(Salaire='[-20K€[',1,
      if(Salaire='[20K€;30K€[',2,
      if(Salaire='[30K€;40K€[',3,
      if(Salaire='[40K€;50K€[',4,
      if(Salaire='[50K€;60K€[',5,
      if(Salaire='[60K€;70K€[',6,
      if(Salaire='[70K€;80K€[',7,
      if(Salaire='[80K€;90K€[',8,
      if(Salaire='[90K€;100K€[',9,
      if(Salaire='[100K€;120K€[',10,
      if(Salaire='[120K€;140K€[',11,
      if(Salaire='[140K€;180K€[',12,
      if(Salaire='[180K€;240K€[',13,14)))))))))))))

       

      However it does not recognize the "Salaire" field, witch is my dimension, is there a system variable to refer to the dimension ?

       

      Many thanks ?