14 Replies Latest reply: Jul 4, 2017 7:24 PM by Sunny Talwar RSS

    Problem with Max[,rank]

    s Walter



      in this thread i asked Expression - Filter for dimension

      if i use a dimension in a chart and want to filter the values of the dimension, how can i do it?

      The answer was for example


      Now i want to use Max() in an expression like this:


      =if(date = Max(Total date,2),Sales,Null())


      The editor shows "ok", but the chart table shows only grey fields.


      I test this expression

      Max(total date,2)


      and this one

      =if(date = Max(Total date),Sales,Null())


      Both shows the correct data.


      What´s wrong in this expression?

      =if(date = Max(Total date,2),Sales,Null())