Hello Experts,
I have data of next 4 years in my database. I have created one date object in universe and I have created prompt on this date object. My requirement is as follows :
User will enter the date through prompt and my report should pull data for next 4 months from entered date and display in report as follows:
e.g If user enters date as 17/02/2011, then report should pull data of next 4 months as follows:
March Apr May Jun
Records for March Records for April ........ .......
I think this should be achivable using Crosstab. But I am not getting exact way to do this.
Any help in this regard is greatly appreciated.
Regards,
Chinmay