5 Replies Latest reply: May 16, 2013 8:22 AM by Suman OTN RSS

    News YTD, YTD LY, MTD measures in OBIEE repository

    987275
      Hello All,

      I wanted some help in creating the following kind of measures:

      1) YTD LY
      E.g if today is 25/12/2013
      It should give the total of all sales from 01/01/2012 to 25/12/2012

      2) YTD
      E.g if today is 25/12/2013
      It should give the total of all sales from 01/01/2013 to 25/12/2013

      3) MTD
      E.g if today is 25/12/2013
      It should give the sum of all sales from 01/12/2013 to 25/12/2013

      Thanks