Cycle Group Demension Sort Issue

[#1]

=if(Week < vCurrentWeek, Week, if(Week = vCurrentWeek, Week & ' - ' & DayOfWeek))

I currently have this as an expression within my date cycle group dimensions. It properly sorts the weeks from 13-1 (current week - previous). But the if statement says if it is the current week then load the days. So the result is as follows if it is current week 14 - 1 (1 being a day of week). However, the 14 shows up at the bottom of the weeks under 1 So when viewing the strait table the dimensions list as follows.

13
12
11
.
.
.
1
14 - 1
14- 2
14 - 3
14 -4

I want the 14 to be on top. Any suggestions?

Thanks

[#2]

John, that works. except now it is showing mon-fri even though I want it to only show currentday -1 (yesterday).

Any thoughts?

Thanks,

[#3]

Actually i just added back my if statement in your example. Works great, thank you!