expression with calculted dimension

[sunnybi]

Hi everyone, 

Hope you all good !

I need your help in this situation : 

I got a cross table with this only  dimension : =if(calendrier.num_sem_fisc<=week(today()) , calendrier.num_sem_fisc)

basically it says : if mydimension(N°of week)<=week(today()) then mydimension(N°of week)

when I pick some value into mydimension(N°of week), the filter says : if(calendrier.num_sem_fisc<=week(today()) , calendrier.num_sem_fisc)

nonetheless, for some expression in this pivot table , i don't want to this filter to be applied . I tried a lot a things but nothing work so far . 

Do you have any advice ? Feel free to ask any question . 

Thanks in advance for help and support ! 

[marcus_sommer · Accepted solution]

Don't use calculated dimensions. In your case you could add this kind of information already within the calendar, for example (simplified):

pick(sign(week(today()) - WEEK) + 2, 'future', 'current', 'past') as Flag

Nearly no period-related information should be created/adjusted within the UI.

If you then want to ignore some selections you could just these fields into a set analysis, like:

count({< Field1, Field2 >} MyKPI)

[Chanty4u]

Try this.

Sum({< calendrier.num_sem_fisc = {"<=$(=week(today()))"}>} Value)