3 Replies Latest reply on Aug 3, 2018 12:37 PM by Ken Pattillo

    LOD for Previous Year (filtered from view)

    Ken Pattillo

      Hi Jedis,

       

      in 2018.1, I have a view that has years filtered by parameters, so you are only viewing the selected year.  I'd like a reference line that shows the previous year's total as a reference line.  I assuming the previous year's total needs to be a fixed LOD because it will not be in scope when the view is filtered for the selected year, correct?

       

      In the attached workbook, on Sheet 3, I've plotted a running total of Monday Sales, and a reference line that I would like to be the previous year's total Monday Sales.  How do I get the calculated field "Monday Sales Previous Year LOD" to give me the previous year's total Monday Sales?

       

      Thanks!  Ken