Analytics Software

Hi ,

I like to achieve a functionality using the RSUM or Timeseries function but any of this would not help .
I have a report to show the sales for last 12 months in such a way that each month of that 12 months will show the sum up all sales for past 11 months + that month .
My requirement is that standing on Month - Apr2009 I like to see the sales value sum from May2008 to Apr2009 ,whereas standing on May 2009 I would like to see the sum of sales for each month from June 2008 to May2009 (where each month sales is not rolling sum rather individual month total sales).While I am using TODATE function in OBIEE 10.1.3.4 version it is showing the sum from Jan 2009 to Apr2009 (like Month to date) but my intension is to show the aggregated value in single dervied column using any of the analytic function to calculate the past 11 months aggregated value + that months sales to be represent in a single metrics.

The difficulty of achieving this by using MSUM is that it works on number of row to be displayed in report .Since I have a filter on date range from current date to currentdate-365 to show the relevant month in this range and to calculate the sum on basis of that.So using MSUM(Sales,12) for first month is not aggregating with past 11 months sales rather only showing that month sales data which is wrong .

Any response to achieve this functionality would be helpful for us .

Thanks in advance,
D