6 Replies Latest reply: May 5, 2017 3:08 AM by Ravi Kishore RSS

    Prior Year YTD, Prior Year MTD,Prior Year QTD in Absence of Date Field

    Ravi Kishore

      Hi Friends,


      Please help me to create Prior Year MTD,QTD,YTD.


      I have attached the Data Sample . I dont have date Field in my Data and i cant use Date field as my data has Granularity for Month wise only. so i cant use today function .


      I was able to calculate MTD,QTD, YTD for Current Year.


      v$MTD Sum({<TYMONTH={'$(vMaxMonth)'}>}TY_NETDOLLARS)/1000000


      But stuck in Creating MTD, QTD YTD for Previous Year


      It would be great help if some one can through some pointers.