Conditional dimension filter

[cocobello3]

Hi all,

I would like to have a dynamic filter for my dashboard on the period.

If the current scenario (year) is selected the period filter should only display monthes until current month.

For example, if we select scenario 2020 period filter should display from January to June.

I was thinking of formula like this (but not working) :

=if(left(GetFieldSelections(SCENARIO),4) = year(today()) and left(PERIOD,2) <= month(today()), PERIOD, all(PERIOD))

Thanks in advance for your help !

[sunny_talwar]

Are SCENARIO and PERIOD not connected to each other in the script?

[cocobello3]

Hi,

To illustrate in a simplified way, it is like this :

Thanks !