1 Reply Latest reply: Aug 30, 2017 7:46 AM by Philippe BONNIN RSS

    CALENDAR MEASURE YTD Last Year

    Philippe BONNIN

      Hi

      To explain my issue i created a simple sample ;

       

      I have 2 files with common dates (3 years ) as shown

      fichiers.png

      Then I created  a calendar measure on CATTC field

       

      measures.png

      So now, i want to  create a graph with comparative analysis CATTC historical / real / goal  over th entire periode (obviously 2 years about the historical)

       

      I obtain that

      graph.png

      my issue :

      CATTC real = CATTC last Year on 2016

      No CATTC historical on 2017

       

      as you see, i don't understand the basic concept :-(

       

      I need some help

       

      regards

       

      Philippe