Rolling week

[amilafdo]

Hi,

I need to create a bar chart for last 12 weeks. Can any one support me to create this.

Thanks

Amila

[amilafdo]

Hi Shiva,

Original file in our server. What I need to have continue week (week no: 50, 51, 52, 1, 2 ... - 1 & 2 is next year)

eg: My financial year finish on 31st March 2017. I want to have 12 weeks trend. ( After 2016-2017 weeks, it need to continue to 2017-2018 weeks. ...., 2016-2017 week 51, 2016-2017 week 52, 2017-2018 week 1, 2017-2018 week 2).

I think this will be more clear.

[Anonymous]

You want next 12 weeks or last 12 weeks form the selected week???

[tresB]

Create a filed in the script to generate Week Sequence, may be like:

AutoNumber(Week&Year) as WeekSeq

And then use front-end expression like :

Sum({<Year, Month,WeekSeq={">$(=Max(WeekSeq)-12) <=$(=Max(WeekSeq))"}>}Data)