Hi,
I have to creat a query looks like:
Mon Tue Wed Thu Fri Sat Sun
Kw50 100 200 300 400 500 200 666
KW49 88 76 54 67 543 100 122
This query i have created, this format is no problem .
In the column i have create 7 columns which look like above (from monday to sunday). Each column is a restricted KF which is restricted by a calender day variable (Customer Exits, from offset 0 bis 6). THis calenderday variable get the date in the customer Exits from monday to sunday.
Input value is Calenderweek.
How can i do it with e.g calender week to get the data for the both weeks?
Thanks!