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



      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