Week numbers as dimension

[#1]

Hi,

I want to make a chart with week numbers as dimension , but the week can be in 2010 , 2011 or 2012.

So I assume I will get the this:

Week 1(2010,2011) week 9(2010,2012)

But I want it like:

Week 1(2010) Week 9 (2010) , Week1(2011) , week9(2012)

I tried this:

Year(DATE)&Week(DATE) as [yearweek]

But some weeks are 1 digit so 20118(year 2011 week 8)is lower then 201015(year 2010 week 15).

What is the good way of doing it?

Kind regards,

ThijsJan

[#2]

Hola,

Prueba con

Year(DATE)&num(Week(DATE)),'00') as yearweek

Saludos

Antoni