1 Reply Latest reply: Aug 31, 2017 10:01 AM by Sunny Talwar RSS

    CALENDAR MEASURE AND PREVIOUS YEAR

    Philippe BONNIN

      Let me explain my issue with a example (app joined)

       

      I have 3 years with CATTC (sales if you prefer) each month

       

      i want to compare for each month :

           évolution CATTC of the year Vs prévious year

      &

           gap between CATTC of the year and goal (goals are datas in a table ) (here is not my issues)

       

      well i did that after created a calendar measure with CATTC

      expression.png

      I have 2 issues in my visualization :

       

      if i select only 2016, sum cattc YTD = sum CATTC YTD last year as you see ??

       

       

      graph6.png

      Secondly

      if i select 2017 ... there is no value in previous year

      graph7.png

      anyone have a idea ?

       

      regards

       

      PS : i have i another solution (thank's sunny) by script in another threads, but i want to progress using CALENDAR MEASURE