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




      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!