10 Replies Latest reply: Apr 24, 2014 4:47 AM by Marco Wedel RSS

    How to sort a custom dimension

      I am "bucketing" values by CloseDate by the following formula:


      =if(MonthName(CloseDate) < MonthName(vTodayDate), 'Before ' & MonthName(Today()),
      if(Year(CloseDate) > Year(Today()), Year(vTodayDate)+1 & '+',




      As of today, the results show:

      "Before Mar 2014"


      Mar 2014

      Apr 2014

      May 2014

      Jun 2014

      Jul 2014




      I want to the "2015+" value to be at the end and I can't figure out how.  I tried using the DUAL function, but couldn't make it work.  Any suggestions?


      Thanks, Dan