1 Reply Latest reply: May 15, 2012 4:42 AM by Antoni RSS

    Week numbers as dimension



      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,