Skip to Content
0
Aug 03, 2016 at 04:04 PM

value of a week and 52 weeks in WebI

150 Views

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