The problem is when you filter specifically on December, you're excluding the underlying data for November 30. In this case, you should just apply your filters based on week numbers if fetching the entire week number is important.
Also, if you didn't need to see sales at a daily level but rather would be OK to see them at a weekly level, you could use a Level of Detail calculation.
Thanks for your help. What I did is I apply year and month filter on the worksheet with week column to have related week only, then apply year filter to all other worksheets and last apply action on week to filter other analytics based on week number selection and not affected by the month selection.