I have a condition:
16 April - 3 May
Week 3 : 16 Apr (Average from 16 - 22 Apr)
Week 4 : 23 Apr (Average from 23 - 29 Apr)
Week 5 : 30 Apr (Average from 30 Apr - 3 May)
I want to have April monthly average numbers based on that three weeks Only when I change the period parameter becomes "Monthly".
But the thing that happens is I got May numbers also.
I will really appreciate for your help. Thank you.