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

    Week numbers as dimension

      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