We had a requirement of creating a chart which should show current week + previous 3 weeks of data with an input control of Week number that is if we enter week 19 in the selection field in input box we can fetch 19,18 ,17 ,16 data . We have now acheived it
Please refer the screenshot of the report which we have created .
However now the requirement changed . Client wanted us to use the week number at query level with the same functionality .
Like -if we put week number filter in the query level and when the user selects the week number while refreshing the report then it should fetch current + previous 4 weeks . Please help me as how to create the same functionality in query filter . It is very urgent.
Looking for your reply