Created a report with 3 column groups . 1. Day wise 2. Weekwise 3. Month wise for the selected date.
1.Let's assume am running the report for 4th week of March(Mar24th based on parameter selected value). my day wise calculations should reflect the current week data. right now its displaying for the 1st week of the month(March first week). I tried to add the filter condition in daywise column group with dateadd -7 validation.It does not work. Any help much appreciated..
Report layout
Sun Mon Tue Wed Thu Fri Sat week1 week2 week3 week4 week5 month
Data 1 22 33 44 55 66 77 1233 1222 1224 1225 0 2133