Creating buckets based on week no's

[hopkinsc]

Hi all,

i have a requirement that i'm unsure of how to do it.

Basically i have some data for current and previous year. i want to create buckets with the week commencing dates of the current year as the values but each bucket would be linked to the corresponding week of previous years.

so for example

W/C Date	Week	Bucket Value//
05/01/2015	1	02/01/2017
04/01/2016	1	02/01/2017
02/01/2017	1	02/01/2017
12/01/2015	2	09/01/2017
11/01/2016	2	09/01/2017
09/01/2017	2	09/01/2017
etc
15/06/2015	24	12/06/2017
13/06/2016	24	12/06/2017
12/06/2017	24	12/06/2017
etc

so i want a bucket for each w/c date of the current year but each bucket would have the corresponding week from previous years too.

i think i only need current and previous, not -2 years, -3 years etc. so currently 2017 and previous 2016

sorry, this is a difficult one to explain!

thanks

[sunny_talwar]

Fingers crossed

[hopkinsc]

Thats great, all seems to work correctly. and ive also added the fuctionalilty to also work for a YTD chart too which is also working.

many thanks for all your help!

its very appreciated

[sunny_talwar]

Super....