5 Replies Latest reply on Nov 10, 2017 2:09 AM by Norbert Maijoor

    Compare current year data with average of previous year in same worksheet

    Michael Raj


      In the current scenario, the dashboard should have a trend of sales of only current year as trend line. Additionally, I need to draw a reference line, which denotes the average of sales of last year. I need help on the reference line of previous year. Also attached a sample worksheet.