Week Numbers to Week Date

[Anonymous]

Hi!  I hope someone can  help me on this.

I have a dimension field [Week Number] that's being made into crosstable .  How  can I add a new field to convert them into weekly date where week 1 will fall on the current week., week 2 = Week 1 +7  and so on.

Thank you in advance.

[hector_munoz]

Hi Caroline,

I attach you a sample in which you can assign a value order to each week: 0 for current, 1 for following, -1 for previous, ...

Hope it serves!

Regards,

H

[asgardd2]

Hello!

What do you want to get in the final table?

Did I understand correctly that you need  this kind of the Table? :

Week 1	4/17/2017
Week 2	4/24/2017
Week 3	5/1/2017
Week 4	5/8/2017

[Anonymous]

Hi!  Hector ,

Where did you get this T1 week and T1 Monday fields?  I can't find this in your excel week file.

This is what I have as table  and I want to add a new dimension weekDate  which is date format.

WeekDate:
CrossTable([Week Bucket], Data, 7)
LOAD Country,
Material,
Customer,
Description,
Type,,
Unit,
[Week Bucket] [Week 1] ,
[Week 2],
[Week 3],
[Week 4],
[Week 5],
[Week 6],
[Week 7],
[Week 8],
[Week 9],
[Week 10],
[Week 11],
[Week 12],
[Week 13],
[Week 14],
[Week 15],

Tks.

[Anonymous]

Hi Anton,

This is my current table.

WeekDate:
CrossTable([Week Bucket], Data, 7)
LOAD Country,
Material,
Customer,
Description,
Type,,
Unit,
[Week Bucket] [Week 1] ,
[Week 2],
[Week 3],
[Week 4],
[Week 5],
[Week 6],
[Week 7],
[Week 8],
[Week 9],
[Week 10],
[Week 11],
[Week 12],
[Week 13],
[Week 14],
[Week 15],

I want to add a new dimension weekDate in crosstable  to look like below....

Tks.

[hector_munoz]

Hi Caroline,

In my example [T1 Week] is like [Week Bucket] in yours and [T1 Monday] is like [Data].

Regards,

H