Based on these sample table I have these customer's information from the 1st of March to the 30 of April 2016. So I created a calendar based on the field Date and I wanted to analyse the data based on Week number. For the two months I expect to see the week numbers from 9,10,11,12,13,14,15, and 16. But instead I am seeing week numbers from 10 through to 18 without week 9 even. So please any help on how to get these done. My desired results is if I click on March, I should see week 9,10,11 and 12. And if its April, I should see week 13,14,15 and 16. Since logically January has week 1 to 4 and February week 5 to 8.
