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,

      Chanel