Author Topic: Order weeks  (Read 1125 times)

Offline Morfeusz

  • Full Member
  • ***
  • Join Date: May 2014
  • Posts: 46
  • Forum Citizenship: +0/-0
Order weeks
« 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

Offline Morfeusz

  • Full Member
  • ***
  • Join Date: May 2014
  • Posts: 46
  • Forum Citizenship: +0/-0
Re: Order weeks
« Reply #1 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.
« Last Edit: 11 Jul 2014 04:50:01 am by Morfeusz »

 


       
Twittear