Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=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
John, that works. except now it is showing mon-fri even though I want it to only show currentday -1 (yesterday).
Any thoughts?
Thanks,
Actually i just added back my if statement in your example. Works great, thank you!