Print Page - Order weeks

Title: Order weeks
Post by: orbair on 04 Jul 2014 05:23:45 AM

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

Title: Re: Order weeks
Post by: orbair on 07 Jul 2014 06:28:51 AM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Query Studio => Topic started by: orbair on 04 Jul 2014 05:23:45 AM