Hello Everyone , I created a calculated column "Week Part " which will show the week number of the month . I used it in the filter so that the data can be filtered by weeks. As it is a calculated column, I am not able to do filter to latest data .My report is getting refreshed every week .Whenever it is getting refreshed , the report is not pointing to the latest data(new data that got refreshed) . How can I resolve this issue , so that whenever the report is refreshed , I can see that the report is pointed out to the latest data.
This is the formula I used to calculate week number .