7 Replies Latest reply on Sep 13, 2017 2:55 PM by Shinichiro Murakami

    Previous 3 Year Avg by Month vs. Current Year's Month

    Nathan Schneider

      I'm trying to display a line graph with two lines: a line by month for the current year, and a line by month where each point is the average of the previous 3 years for that month.

       

      Example, I want to show the current year's total for January 2017, and I want to see that compared to the average of the previous three Januaries (2014, 2015 and 2016).

       

      I'm able to get those results in a crosstab.

       

       

      But I'm having trouble translating this crosstab into a line graph. I would want to hide all prior fiscal years in the graph and only present the two lines for the current fiscal year.