topic Re: expression with calculted dimension in App Development

expression with calculted dimension

sunnybi — Tue, 19 Aug 2025 14:11:20 GMT

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 — Tue, 19 Aug 2025 14:54:40 GMT

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 — Wed, 20 Aug 2025 18:12:17 GMT

Try this.

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