Hi,
I am trying to create a report in WEBI Where I have 3 columns 1)Date 2)Amount 3)12 months rolling amount
Date object I have formatted it in the universe to get the MON-YYYY, So that I can the data by months, And its working correctly.
In the report I am getting data like this.
Date Amount Jan-2008 5000 Feb-2008 6000 Mar-2008 8700 Apr-2008 5500
I want another column for 12 month rolling amount which show the data from for last one year.
example : Jan-2008 for 12MonthRolling Amount column I should get the total of Jan-2007 to Dec-2007 Feb-2008 for 12MonthRolling Amount column I should get the total of Feb-2007 to Feb-2007
User will be having the prompt to select the Date Between
I have created the Measure for 12 month rolling amount to select the last 12 month total based upon the prompt.
In the select for this object I have
Select TableName.Amount Where @Select(TableName\Date) BETWEEN DATEADD(month,-11,@prompt('Enter Date (Start):','D','TableName\Date',Mono,Free,Persistent,,User:0) ) AND @prompt('Enter Date (Start):','D','TableName\Date',Mono,Free,Persistent,,User:1)
I don't Know If I am doing it correct or not. Can anybody please suggest me or show me the correct way to do it.
Please help !
Thanks Techza
|