4 Replies Latest reply: Jun 22, 2018 9:47 AM by Patricia Thomas RSS

    Rolling 12 for date Dimension

    Patricia Thomas

        I've got a date dimension and I'd like to limit that dimension to a rolling 12 view instead of all of the dates available.

       

      I have a variable that I have created vMaxDate12 which is

       

      =addmonths(Date(Max([ROLLING_DATA.Date.autoCalendar.Date]),'YYYY-MM-DD'),-11)

       

      I'd like to set up a dimension to be: IF(AS_OF={'$(>=(vMaxDate12)'},AS_OF) and I keep getting an invalid dimension. Any help would be greatly appreacited!