4 Replies Latest reply: Jan 5, 2015 11:56 AM by Lior Abitbol RSS

    Assign numbers to months for custom ordering

    Steve Dillon

      I want to be able to order my charts using our business' fiscal year. I'm guessing the best way to do this would be to assign each month a custom numeric value so that I could then sort the chart by this value? For example, here is how I would assign the numbers to each month:

       

      1 = July

      2 = Aug

      3 = Sept

      4 = Oct

      5 = Nov

      6 = Dec

      7 = Jan

      8 = Feb

      9 = Mar

      10 = Apr

      11 = May

      12 = Jun

       

      I'm sure there are multiple methods to accomplish this, so I'm open to any and all suggestions. Thank you.