3 Replies Latest reply: Dec 12, 2014 8:53 AM by Bill Markham RSS

    Expression to sort chart by two expressions

      Hello,

       

      I have a dimension comprised of two fields - Month and Year (=%Month&' - '&%Year).

       

      I want to sort my chart so that the order is chronological (Nov-13, Dec-13, Jan-14, Feb-14, etc.). Presumably I need to sort by year first, then by month. Does anyone have an formula that will work for this?

       

      Thank you

      Mel