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 & '+',

      MonthName(CloseDate)))

       

       

      As of today, the results show:

      "Before Mar 2014"

      "2015+"

      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