This discussion is archived
5 Replies Latest reply: May 16, 2013 6:22 AM by Suman OTN RSS

News YTD, YTD LY, MTD measures in OBIEE repository

987275 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points