I am trying to create a report in WEBI Where I have 3 columns
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.
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 end Date
I have created the Measure for 12 month rolling amount to select the last 12 month total based upon the prompt.
Please suggest me if you get any idea on this requirement.
Its very urgent...
Thanks in Advance,