2 Replies Latest reply: Nov 19, 2014 5:35 AM by Jason Lai RSS

    Show last 13 months as a calculated dimension

    Jason Lai

      Hello,

       

      I am trying to show just the last 13 months as a calculated dimension in a Month-Year format for a chart, but it doesn't seem to work.

      My MonthYear field is created by the following expression:


      Date(MakeDate(Year(MyDateField), Month(MyDateField),1), 'MMM-YY') as MonthYear


      Do I create the expression as a calculated dimension or should it be done as a set analysis expression?

      If so, what expression should I use?


      Cheers,

      Jason