Order weeks

[orbair]

Hi all,

I have a dimension, which contains W1, W2 calculated 'W' || cast( _week_of_year ( [Physical Layer].[date2].[date] ), char(2)).  I would like to sort in my report W1, W2, W3 but my sorted list looks like W1, W11, W12.... Can someone help me in this issue?

Thanks

[orbair]

I have created an Order_week member number only,made a rank on it  and sorted by that one.