8 Replies Latest reply: Dec 2, 2013 5:54 AM by Chanel Choo RSS

    Calculated Dimension - expression

      Hi community,


      I want to display my chart from first week until last 6th weeks, I cannot limit it to show first xx weeks, because the week will keep increasing in the future, so i decided to write expression for dimension as shown below, but it is not working.

      Appreciate if you could help.


      Calculated Dimension:

      =if(WeekDim < (max(WeekDim) - 5), WeekDim)



      Thanks and best regards,