Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

For eg.

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>

<b>Release date</b>

<b>Actual Sales</b>

<b>Target sales</b>

Please suggest me how to do this.

Thanks,

Sudhakar.

Not what you were looking for? View more on this topic or Ask a question