I have a report that has the following grouping:
Year
Month
Week
Day
The report then asks the user what they want to see. For instance if they chose just Year/Week/Day. The report will display like this:
Year
Week
Day
The problem I'm running into is having the report group by just the week. What's happening is that the Month grouping is always taking precedence and so at the end of the month the weeks get cut up if they fall between both months. Is there a way to eliminate the month grouping depending on the selection of the user?
IP Logged