Hi ,
I'm trying to get a previous week (Week number) and last 52 weeks from Current date values to display in WebI.
Tried to get Current Week which is 32 and corresponding count in report but if I remove Week Number from report, It is summing up.
I have Date, Dept, E-Id column. Need Count of E-Id's for Previous Week and rolling average for 52 weeks for each Dept
Must be missing a logic somewhere, any help on this is appreciated.
Thanks,
Jothi