Hi Experts,
I want to make Webi Report which is Daily Report on top of Universe.
I Have Requirement In Webi of field MTD , YTD and Data of Last 12 Month so there will be 14 fields.
I have the prompt for today's date. e.g 3rd december 2011.
When i run the report, i want the value to show for the current month. i.e 1-3 dec as of MTD.
And in another column i want to show the value to show from 1st Jan to 3rd dec. ie. YTD.
and i also want to show 12 seperate column which shows the value for the last 12 month. i.e from dec 2010 to nov 2011.
All this has to done in Webi only. I am having only prompt of Current Date or as per user Change date of report will run on that date.
Can anyone help how to go for this.??
Thanks in advance,
Warm Regards,
Chintan Vora.