3 Replies Latest reply on Apr 28, 2017 11:39 AM by Marc Levy

    Text Label Showing Month over Month Difference with a Weekly View?

    Marc Levy

      I want to show a label at the end of a trend line that shows the Month over Month difference (the difference between March and April).  Note that I'd like to keep the view of the trend line at the weekly level [WEEK(DATE)].

       

      I do not wish to manually annotate as I have dozens of charts like this one and they will be changing each month.  Instead, a calculated field for the text label would be great.  What would the calculation be?

       

      Attached is a sample workbook.  Ideally the solution could be included in a workbook with a brief explanation in the reply.

       

      Thanks,

       

      Marc