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
