3 Replies Latest reply on Mar 23, 2017 7:25 AM by Michael Someck

    Highlighting trailing 3 months based on month selected

    Padhumai Rathinavel

      Hi,

       

      I've been working on this issue for quiet some time now.I basically want the trailing 3 months from the month selected to be highlighted in a different color in the bar chart. For example - if I select Dec-16 then the months OCt-16,Nov-16 & Dec-16 should be highlighted in a different color compared to the other bars in the chart which remain the same.

       

      Also Ive not been able to find a formula that would capture trailing 3 months based on month selected.

       

      IT would be great if someone gave me any pointers on this.

       

      Thanks,

      Padhumai