show condition for season's week

[Anonymous]

hi all,

i have a table that sums production by weeks.

the weeks appears as expression.

something like that:

product	week35	week36	week37
1	100		200
2		200
3	100

the season starts at week 35 (September).

i wish to show only past weeks when the future weeks are hidden.

my condition is Week(Today())>='week no.'

problem: on the first weeks of the year, i need to present weeks with larger week number then today's week

glad for any assistance

thanks

avner

[Anonymous]

Hi Avner

Try to create a new concatenated dimension of Year and Week (i.e. 201301-201352).

Than try to change the condition to:

Year(today())&Week(today()) >= 'YearWeek'

Yaniv

[Clever_Anjos]

Concatenate year before your week number

[Anonymous · Accepted solution]

Hi,

Tanks for the help, but since i have also future dates on my model i couldn't use it.

anyway my solution is to create two different conditions, depending on the week's number (over or under 35).

for weeks above 35 : if((Week(Today())<'35'),1,Week(Today())>='Week no.')

for weeks under 35: if((Week(Today())<'35'),Week(Today())>='Week no.',0)

Cheers

Avner