Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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 |
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.
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.
Hi Caroline,
In my example [T1 Week] is like [Week Bucket] in yours and [T1 Monday] is like [Data].
Regards,
H