2 Replies Latest reply on Apr 15, 2016 4:50 PM by Patrick A Van Der Hyde

    Rolling Calculation Within Year and previous year reference

    Harnish Patel

      Hi All,

       

      What I'm looking to do is keep a rolling calculation within a year: so want 2014 Months to be incrementally added to the previous until the end of the year, then i want to show that as my baseline.

       

      Then I want to show the trend of 2014, 2015, and 2016 as 3 different types of marks on my visual.

       

      Then, on the same visual I would like a target line that shows YTD 2016 (so Jan + Feb) - (the End of Year rolling sum of 2014)

       

      I know this is a lot to ask but this sums up my many asks in one simple work book

       

      Thank you!!