Dynamic bookmark with two values

[beck_bakytbek]

Hi Folks,

i have a question: is that possible to create a dynamic bookmark with 2 values:

For instance: my data do look like:

MyYear, Turonver

2022 , 100

2021, 50

2022, 25

i created a dynamic value with only 1 value and it does work: =MyYear = Year(Today())

i tried to expanded this expression and created this expression: =MyYear = Year(Today()) and Year(Today())-1 but it does not work.

Has anyone experienced similar case and does anyone have an idea how to create a dynamic bookmark with 2 values. I only want to show the current and previous year when i activate my bookmark.

Thanks a lot

Bek

[justISO · Accepted solution]

Hi, have you tried >= without 'and' condition?:

=MyYear >= Year(Today())-1

If this not work, maybe set analysis could help here, something like this:

{<MyYear={"=MyYear>=year(today())-1"}>}

[beck_bakytbek]

Hi @justISO  thank you very much, it does work,

thanks a lot for your time and your help