4 Replies Latest reply: Jan 27, 2017 3:40 AM by Vineeth Pujari RSS

    Show 3 Fiscal Years Trend

    Jia Sheng Loh

      Hi experts!

       

      I want to show a 3 Fiscal Year(FY) trend on multiple line chart.

       

      I have a data columns in my excel telling me the fiscal year the transactions is, but I am not sure how to show 3 FY  trend.

      fiscal Year Trend.PNG

       

      Here, it is showing me 4 FY trend, which is what I have in my excel data. Now I only want to  show 3 FY ( Current FY and pas 2 FY)

       

      How do I script it to show only 3 FY?

       

      Regards,

      Frederic