7 Replies Latest reply: Apr 4, 2017 9:37 AM by Sunny Talwar RSS

    Cumulative expression quarters

    Mike Slottje

      Hi guys,

       

      I want to show our sales in the current year vs the cumulative sales of the quarters last year. At this period of the year, this means that I need to show the cumulative sales of Q1 and Q2. I want a function that automatically shows the the cumulative sales of Q1, Q2 and Q3 when Q3 has started.


      I tried the following script, but that did not work as I hoped for:

      SUM({1<Date ={">=$(=date(QuarterStart(=max({<year>}Year)-1))) <=$(=date(QuarterEnd(Today(),-4)))"}>}[Nett Amount new EUR])

      Any ideas?


      Cheers,

      Mike