Week, Month,Quarter and year
I have a specific query. I my dashboard i have prompts for Year, quarter, month and week.
Based on the week selection i get some sales data. And i use AGO function to get previous week's data.
Now i am in a fix with my other requirement. I need the monthly data and quarterly data, for that particular week.
Example:-
Week 19th Nov 2011. I am ale to get the data with existing report.
Month NOV:- If i use todate fundtion then i will get November's data untill Week of 19th November. BUT I WANT FULL NOVEMBER'S DATA.
Quarter 2011-4:- If i use todate fundtion with quarter parameter then i will get fourth quarter's data until Week of 19th November. BUT I WANT FULL FOURTH QUARTER'S DATA.
How do i achieve this.