5 Replies Latest reply on Feb 27, 2017 2:06 AM by James Austin

    Automating the axis month order to change each month

    Lucie Brett

      Hello,

       

      In the attached file, I am showing three year cycles. I would like the axis to start at the current month minus 8 so at the moment it would go from June - May, that is so that we can see 3 months ahead with no line for the current year but for previous years the lines do extend as these months have already passed.

       

       

      In the attached file, I had some help to try and start doing this using the calculated fields "First" and "Second" but they aren't working and I have to sort the months manually.

       

      If anyone has done this before, I'd love to hear how.

       

      Thanks in advance