Weeks calculation from the date
Hi BW mates,
I am currently working on SCM Queries. I have a report where I have to display the sales for 16 weeks from the date of release of cinema.
In rows, Title and Release date are displayed in rows. In columns data is displayed with Wee1, Week2,,,,,,,,,up to Week 16.
Generally using Off sets we can achieve using current week. But here I have to consider the release date. The release date is nothing but the equals to current week from there it has to show all 16 weeks invidually
<b>Title</b> <u>Week1 Weekk2 Week3 Week4</u>
Please suggest me how to do this.